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)

"DIANE K" wrote:

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.

"mrsthickness" wrote:

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