Re: [belajar-excel] perbandiangan 2 daftar 2 kriteria-update attachment

2011-09-30 Terurut Topik Kid Mr.
Btw data nya perlu di sorting dulu gak yah? >> Bagaimana kalau bapak coba sendiri. Sepertinya sih data unsorted juga gak apa-apa (sepertinya loh...) hehehehe... coba saja deh ya biar manteb mudengnya. Kid. 2011/9/30 Jonathan Susanto > ** > > > Thanks Pak Kid dan Pak Ruswanto, > > Nanti di coba

Re: [belajar-excel] perbandiangan 2 daftar 2 kriteria-update attachment

2011-09-30 Terurut Topik Jonathan Susanto
Thanks Pak Kid dan Pak Ruswanto, Nanti di coba dulu. Btw data nya perlu di sorting dulu gak yah? On 30/09/2011 13:29, Kid Mr. wrote: Coba array formula : =ISNUMBER(MATCH(F3&G3,$C$3:$C$13&$D$3:$D$13,0))*1 Kid. 2011/9/30 Jonathan Susanto > � Dear

Re: [belajar-excel] perbandiangan 2 daftar 2 kriteria-update attachment

2011-09-29 Terurut Topik Kid Mr.
Coba array formula : =ISNUMBER(MATCH(F3&G3,$C$3:$C$13&$D$3:$D$13,0))*1 Kid. 2011/9/30 Jonathan Susanto > ** > > > Dear Be Exceller. > > Maaf, ada update di sample data biar lebih clear problemnya. > > Thanks > Jonathan > > > re-Banding2criteria.xls Description: MS-Excel spreadsheet