How can I compare 2 sets of Social Security #'s and Identify dupes

[vwwolfe]

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.

[Bob Phillips]

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" <vwwolfe@discussions.microsoft.com> wrote in message
news:94DDF32D-4790-40E4-87D0-6B52BF406587@microsoft.com...
> 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.