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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unformating social security numbers 4
Compare Data in two Separate Worksheets 3
Calculating Social Security 3
Social Security Numbers 2
How do I change a social security number to a number series? 4
Hiding part of a Social Security Number 1
How do I de-dupe two columns of data in excel? 3
compare two columns and pull out differences 1

Back
Top