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