RE: ]] XL-mania [[ rekap kode kode

[Farid Abdurrahman]

Saran saya bikin kolom baru dulu buat nampung kode yg diinginkan (kode dg karakter sebelum tanda "-") baru dibikin pivot table-nya. File terlampir.   From: "albirru" <[EMAIL PROTECTED]> Date: Wed Apr 19, 2006  10:55 am Subject: rekap kode kode    aku mau bikin rekap, kode yang diambil adalah kode sebelum "-", kodenya tidak terbatas. caranya gimana ya? tanpa menggunakan fasilitas subtotal. pake macro juga gpp. ----------------------------------------------------------------------------------- PRIVILEGED AND CONFIDENTIAL (Disclaimer) ----------------------------------------------------------------------------------- This e-mail message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure. If you are not the intended recipient, please do not disseminate, distribute, or copy this communication, by e-mail or otherwise, or take any action in reliance on it. Instead, please notify us immediately by return e-mail (including the original message in your reply) to [EMAIL PROTECTED], and then delete and discard all copies of the e-mail. +-:: XL-mania ::::::::::::::::::::----------------------------------+ |                                                                   | | 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  | | [EMAIL PROTECTED] atau kirimkan mereka file dari | | http://groups.yahoo.com/group/XL-mania/files/Promotion/           | +-------------------------------------------------------------------+ | Berikan testimoni Anda tentang XL-mania di :                      | | http://www.friendster.com/profiles/xlmania                        | +-------------------------------------------------------------------+ SPONSORED LINKS Business application software Microsoft excel training Microsoft excel tutorial Business application development Microsoft excel help Microsoft excel training course YAHOO! GROUPS LINKS  Visit your group "XL-mania" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

pivot.xls
Description: pivot.xls