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

[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 <jonathan.susa...@gmail.com <mailto:jonathan.susa...@gmail.com>>

    �

    Dear Be Exceller.

    Maaf, ada update di sample data biar lebih clear problemnya.

    Thanks
    Jonathan