Comparison / Check Off between 2 excel sheets. HELP NEEDED!

[sax30]

Hi Max,
I really appreciate your help. It works like a charm and will save me
lot of times. Thanks again!

An observation .. think from where you're reading this [
"excelbanter.com" ], the formula below has been slightly distorted
There's
a missing "less than" symbol just after the COUNTIF(...), before th
"1".
Ensure that this missing symbol is inserted. Anyway, the sample fil
[link
posted earlier] contains the working implementation
-
Put in F2: =IF(C2="","",IF(COUNTIF(Sheet1!C:C,C2)1,ROW(),""))-

 

[Max]

Great to hear that !
Thanks for the feedback ..