Removing Duplicates

XL 2002 SP3, Win XP HE SP1
Follow up to: microsoft.public.excel.misc

Hi, what is the BEST way to remove duplicate cells (phone numbers, email
addresses, etc.) from a long list in Excel?

The duplicates usually would be in 1 column (Column "A: for example)

Tx. S

Select the column. Then Data > Filter > Advanced Filter > check unique
records only. If you later want to restore the duplicates, you can. If you
want to permanently delete the duplicates, copy the column elsewhere.
--
Gary's Student


"sat" wrote:

> XL 2002 SP3, Win XP HE SP1
> Follow up to: microsoft.public.excel.misc
>
> Hi, what is the BEST way to remove duplicate cells (phone numbers, email
> addresses, etc.) from a long list in Excel?
>
> The duplicates usually would be in 1 column (Column "A: for example)
>
> Tx. S
>
>
>