removing duplicate values from a column

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

 

[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