removing duplicate values from a column

J

Jops

It sounds so simple that I must be overlooking the obvious answer, but I
can't seem to find a way to remove duplicate values from a column.

The case is simple: I have 600+ emailaddresses in column A, sorted
alphabetically and there's a bunch of duplicate addresses in there (some of
'em occur up to 7 times!!). Instead of manually running through the whole
list, removing the duplicates, there MUST be some soft of filter/function in
excel to do this for me... Could anyone PLEASE help me with this!?!?

Cheers!
 
B

Bernie Deitrick

Jops,

Select the email addresses, then use Data | Filter | Advanced Filter, Check "Unique Records only" and "Copy to another location",
and select a cell for the "Copy To" range. Then delete the original list.

HTH,
Bernie
Excel MVP
 

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 find duplicate column (not the cell values) 3
How do I apply a formula to a whole column at once? 3
is there a simple formula that will remove all duplicates 3
is there a simple formula that will remove all duplicates in a simple list 1
Show only rows with duplicate values in a column? 2
Removing duplicates 7
Removing Duplicate Values 1
Locate text in range (multiple occurrences) and report other cell insame column? 25

Top