Use a formula of

=IF(COUNTIF(A:A,B1)<0,"Duplicate","")

in C1, and copy down

--

HTH

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


"vwwolfe" wrote in message
...
I'm sure this can't be that difficult but for some reason it's just not
working for me. I have 2 lists of social security numbers that I need to
compare and pull out duplicates. Any help would be greatly appreciated.
Thank You.