thx Mr Kid and Haps..verry good. sangat membantu sekali...
----- Original Message ----- From: Mr. Kid To: [email protected] Sent: Friday, July 08, 2011 4:53 PM Subject: Re: [belajar-excel] Menarik data menggunakan tanggal Mungkin seperti file terlampir. Sayang, datanya tidak tersusun sebagai tabel berkaidah database, padahal keinginannya bisa membuat summary dengan banyak macam bentuk. Summary akan semakin sulit kedepannya jika struktur data seperti itu masih dipertahankan. Sebaiknya upayakan penyusunan atau penggunaan data yang tersusun berkaidah database. Contoh header tabel untuk seluruh nama orang : Nama Tanggal DataA DataB DataC DataD Jika DataA sampai DataD adalah suatu item berupa satu jenis makna (seperti nama cabang), maka susunan header bisa : Nama Tanggal Cabang Nilai Regards. Kid. On Fri, Jul 8, 2011 at 15:45, Rey <[email protected]> wrote: Mohon dibantu.. saya ingin menarik data di sheet yang ada tapi hanya mengimput tanggal saja..hasil yang saya inginkan munculnya nama, tanggal dan data-datanya. terima kasih... Rey PT. BANK ARTHA GRAHA INTERNASIONAL TBK. DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. PT. BANK ARTHA GRAHA INTERNASIONAL TBK. DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.
