Buat 1 kolom bantu berisi formula : =--text(cell_tgl,"mmyyyy") lalu sort pada kolom bantu itu sesuai kebutuhan.
Regards. Kid. On Thu, Jul 8, 2010 at 8:15 AM, Rey <[email protected]> wrote: > > > hai pakar exel.... > tanya lagi nih...biasanya aku sort tanggal/bulan/tahun selalu hasilnya dari > tahun paling sedikit ke banyak atau sebaliknya. > nah kalau sort hasilnya urutan bulan bukan tahun gimana? > > TQ > > > > > > > > > > > > > > > > > > > > > > > > > > > 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. > > >
