Macro to remove duplicates

G

gwh

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi everyone,

I'm looking for a macro that will automatically remove duplicate email addresses from an excel file. The file just consists of one column and about 2000 email addresses but I think there are a lot of duplicates.

Would anyone know where I can find such a macro?

Appreciate any help.
 
J

JE McGimpsey

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi everyone,

I'm looking for a macro that will automatically remove duplicate email
addresses from an excel file. The file just consists of one column and about
2000 email addresses but I think there are a lot of duplicates.

Would anyone know where I can find such a macro?
Click to expand...

You could use a macro, but it would probably be simpler to do an
advanced filter:

http://www.contextures.com/xladvfilter01.html#FilterUR
 

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

How to delete duplicates? 21
Can Filter and extract the duplicates out? 5
Find Duplicates Across Multiple Lists 0
Emailing from an excel list 1
Remove duplicate data 1
How to count duplicates... 1
Applescript to format a cell to date 1
Copying email addresses into email 1

Top