Re: ]] XL-mania [[ Memunculkan data di sheet yg berbeda pada masing² category

 

Dear Pak Kus;

 

File terlampir semoga sesuai harapan

 

 

Bagus

 

Sent from my Taxiphone®

----- Original Message -----

From: Kusmiyanto

To: 'XL-mania@yahoogroups.com'

Sent: Thursday, June 21, 2012 1:26 PM

Subject: ]] XL-mania [[ Memunculkan data di sheet yg berbeda pada masing² category

 

Dear XL Mania

 

Bagaimana cara & formula agar data di sheet Detail tepatnya nilai total CIF (kolom D) pada masing² Category (kolom C) bisa muncul di sheet Summary pada masing² Bill Of Ladding Number (kolom C) dan masing² Category (kolom K1: DC1)

 

Hasil yg saya inginkan seperti dilampiran ini

Data di actegory A9800 (kolom S) ini didapat dari sheet detail, tepatnya dari jumlah total CIF dari masing² Category & Bill Of Lading No

 

Atas bantuan & pencerahannya saya sampaikan terima kasih

 

Rgds

Kus

---------------------------------------------------------------------------
The content of this message may contain the private views and opinions of the sender and does not constitute a formal view and/or opinion of the company unless specifically stated. The contents of this email and any attachments may contain confidential and/or proprietary information, and is intended only for the person/entity to whom it was originally addressed. Any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this email in error please notify the sender immediately by return e-mail and delete this message and any attachments from your system.

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 51

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Woooowwww... member XL-mania tembus 20,000!!!                     |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___