Coba Juga, =if(isblank(C8),"",row(B7)-6)
C8 = Isian nama B7 = Judul kolom no 6 = Jumlah baris sebelum judul kolom No fandy --- On Fri, 5/21/10, Mr. Kid <[email protected]> wrote: From: Mr. Kid <[email protected]> Subject: Re: [belajar-excel] No urut otomatis To: [email protected] Date: Friday, May 21, 2010, 1:12 AM format number kolom No dengan #;;; agar tidak ada running reference ketika banyak record, pada b8 gunakan formula =(c8<>"")*(n(b7)+1) Kid. 2010/5/21 Utam Thea <musafir_ardl@ yahoo.com> Gimana caranya agar no urut otomatis,bila kolom yang lain di isi???
