Getting Rid of Duplicate entries?


W

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!!
 
Ad

Advertisements

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top