Getting Rid of Duplicate entries?

[Wendy]

I have a customer list in excel of 5000 emails. They are
all alphabetized. I now want to find all the dupes and
delete them. I don't want to eyeball it, I'd rather have
excel find the dupes and let me delete them.

Any ideas on how I can do this in Excel?

Thanks!!

 

[Biff]

Hi Wendy,

You could use an advanced filter to create a new list of
unique items and then delete the original list. It's
actually very easy but look in XL Help for Advanced Filter
for instructions.

This site is also a good place for info:

http://contextures.com/xladvfilter01.html

Biff