Pak Samsudin, Coba manfaatkan fitur Excel Pivot Table. Pada Excel 2010 ke atas, juga ada fitur Power Pivot. Di Excel 2010, Power Pivot masih memerlukan peng-install-an. Power pivot menjadi add in yang otomatis terinstall dan ter-load mulai di Excel 2013.
On Fri, Sep 4, 2015 at 6:44 PM, Samsudin samsu...@bayan.com.sg [belajar-excel] <belajar-excel@yahoogroups.com> wrote: > > > Dear Master Excel, > > Saya punya masalah sebagai berikut ada data pemakaian spare part bulan > dengan dg susunan tabelnya : > 1. Control no > 2. Date > 3. Item no > 4. Descript no > 5. Categori > 6. Qty > 7. Unit > 8. Amount > 9. Cost > > Dari tabel tersebut saya ingin ringkasan yg terdiri : > 1. Kolom pertama berisi control no (header) dan baris kedua dst berisi > control no > 2. Kolom kedua sampai kolom ke 31 berisi date (header) dan baris kedua dst > berisi cost dari categori yg dipakai berdasarkan date dikeluarkannya spare > part tsb. > 3. Data ini sebagai key adalah categori > > Terima kasih atas pencerahannya. > > > Hormat saya, > > Samsudin > > > Dikirim dari perangkat Samsung E7 saya > > --------------------------------------------------------------------------------------------------- > > This message (including any attachments) contains confidential information > intended > for a specific individual and purpose, and is protected by law. If you are > not the > intended recipient, you should delete this message and hereby notified that > any > disclosure, copying, or distribution of this message (or any part thereof), > or the > taking of any action based on it, is strictly prohibited. No liability or > responsibility > is accepted if information or data is, for whatever reason corrupted or does > not reach > its intended recipient. No warranty is given that this email is free of > viruses. The > views expressed in this email are, unless otherwise stated, those of the > author and > not those of the Company or its management. The Company reserves the right to > monitor, > intercept and block emails addressed to its users or take any other action in > accordance > with its email use policy. > > >