Matching Entries of Two Column

M

mazalam

Column A has 962 entries. Column C has 898 entries. I want to find out,
in Column B, entries that are in column A but not in Column C.


Thanks in advance.
Mazhar
 
B

Bob Phillips

in d1

=IF(COUNTIF(C:C,A1)=0,"Not found","")

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top