Trying to remove duplicates within one column can someone help

If your Data is in Column A , beginning in Cell A2
enter the following fomula in B2 and Copy down

=COUNTIF(A$2:A2,A2)>1

You will see True/False; All that are True are Duplicates
Suggest you do an AutoFilter Selecting True; and while
filtered, Delete all Selected Rows. Then Unfilter

"scavvie" wrote:

> Trying to remove duplicates within one column can someone help

Excel 2003.............Data>Filter>Advanced Filter.

Unique records only and copy to another location.

Excel 2007.............Data>Sort and Filter>Advanced Filter


Gord Dibben MS Excel MVP

On Mon, 4 Jan 2010 07:16:02 -0800, scavvie
<(E-Mail Removed)> wrote:

>Trying to remove duplicates within one column can someone help