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