how do i find and delete duplicates in excel worksheet?

M

mrsthickness

I have combined several mail list into one on excel workshett and have quite
a few dupicates. How can I find and delete duplicates?
 
D

DIANE K

I wasn't able to find anything in excel that would accomplish this. I had
the same problem and bought DIGDB and excel add in. I couldn't live
without, it is a wonderful tool to use in exel.
 
S

SFrost

I use the following formula in a list to find duplicates. It doesn't auto
delete but helps you detect easily. Of course you need to ensure your list
is sorted alphabetically and then the formula looks above and below a line
for duplicate:

=IF(OR(A5=A6,A5=A4),"dup",0)
 
Top