Duplicate enteries
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.
|