| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
