It worked. Thank you very much!

"Tim879" wrote:

Here are some ideas....

1) use Data- Filter- Advanced Filter. make sure to check the Unique
rows option

2) Sort the SSN column. Assuming you have you SSN in Col. B cells 1
to 100, use this formula. =countif(b1,$b$1:$b$100). Any number 1
means you have a duplicate entry

3) Sort the SSN column. Assuming you have you SSN in Col. B cells 1
to 100, use this formula. put a 1 in cell A1. In A2 use this
formula... = if(b1=b2,0,1). Any number = 1 means you have a unique
entry.




On Jun 23, 2:04 pm, boba wrote:
Is there a way I could querry or sort out duplicate enteries by social
security number from a large excel sheet.