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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I compare 2 sets of Social Security #'s and Identify dupes (https://www.excelbanter.com/excel-discussion-misc-queries/11461-how-can-i-compare-2-sets-social-security-s-identify-dupes.html)

vwwolfe

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

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" 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.

All times are GMT +1. The time now is 07:15 PM.