Agar formula pada baris data pertama (sel B3) sama dengan baris berikutnya (sel B4 dstnya), formula dapat diubah seperti ini : =IF(COUNTIF($A$3:A3,A3)>1,VLOOKUP(A3,$A$3:B3,2,FALSE),1+MAX($B$2:B2)) Perubahannya dibold. Salam, Hendrik Karnadi --- On Tue, 5/7/11, M. Ferdiansyah <[email protected]> wrote:
From: M. Ferdiansyah <[email protected]> Subject: Re: [belajar-excel] masih tentang nomor urut To: [email protected] Date: Tuesday, 5 July, 2011, 11:16 AM Dear Pak Iwan, Selagi menunggu jawaban dari master" excel, izinkan saya untuk menjawab ya.. regard, Ferdy *File terlampir ____________ _________ _________ _________ _________ _________ _________ Notice : This e-mail (and any attachment) is strictly confidential and is intended only for the addressee(s)above. Is strictly prohibited to forward, print, copy, or otherwise reproduce this message that would allow it to be viewed by any individual not originally listed as a recipient(s). If you have received this e-mail in error, please immediately notify the sender and delete this message. The opinions expressed in this e-mail (and any attachment) are those of the individual sender and may not necessarily reflect the views of PT Pusri. ____________ _________ _________ _________ _________ _________ _________
