kalau untuk keperluan pengelompokan data ( summary per bulan ) gunakan =TEXT(B3,"YYYYMM") dan data akan di sort secara benar
From: [email protected] Date: Mon, 12 Sep 2011 12:46:41 +0800 coba isi cell C3 yang sebelumnya berisi formula dengan formula =B3 copy ke bawah dst. wassalam Ghozi Alkatiri --- Pada Sen, 12/9/11, [email protected] <[email protected]> menulis: Siang pak ghozi dan mba siti. Sudah saya lakukan. Tp ketika saya coba pivotkan utk melihat pengelompokan perbulan, malah berurut berdasarkan abjad (mungkin krn format text td ya). Bagaimana caranya agar beurut berdasarkan bulan pada 2010 dan 2011 ya? Terima kasih ------------------------------------ --------------------------------------------------------------------- bergabung ke milis (subscribe), kirim mail kosong ke: [email protected] posting ke milis, kirimkan ke: [email protected] berkunjung ke web milis http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran http://www.mail-archive.com/[email protected]/ atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ menghubungi moderators & owners: [email protected] keluar dari membership milis (UnSubscribe): kirim mail kosong ke [email protected] ---------------------------------------------------------------------Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-excel/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-excel/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
