awal baris=LEFT(B2,3) & "-"& YEAR(C2)& "-" &TEXT(MONTH(C2),"0#") & "-" & TEXT(1,"00#") baris berikutnya :=LEFT(B3,3)&"-"&YEAR(C3)&"-"&TEXT(MONTH(C3),"0#")&"-"&TEXT(VALUE(RIGHT(F2,3))+1,"00#")
B C D 2 KTU-SMD 6/20/2011 KTU-2011-06-001 3 KTU-BPP 6/23/2011 KTU-2011-06-002 4 GDR-PNJ 6/23/2011 GDR-2011-06-003 5 STK-PNJ 6/26/2011 STK-2011-06-004 6 STK-PNJ 6/27/2011 STK-2011-06-005 To: [email protected] From: [email protected] Date: Thu, 23 Jun 2011 10:35:16 +0800 Subject: [belajar-excel] Masalah penomoran lagi ... Dear semua, Aku punya PR seperti terlampir di bawah, sudah coba berbagai macam pake contoh data milis sebelumnya.., tp msh mentok ..Mohon pencerahannya yaa .. Data : : data tanggal : Output penomoran yg diinginkan :KTU-SMD : 20/06/2011 : KTU-2006-001KTU-BPP : 23/06/2011 : KTU-2306-002GDR-PNJ : 23/06/2011 : GDR-2306-003STK-PNJ : 26/06/2011 : STK-2606-004STK-PNJ : 27/06/2011 : STK-2706-005 Salam,Yulius
