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.............DataFilterAdvanced Filter.

Unique records only and copy to another location.

Excel 2007.............DataSort and FilterAdvanced Filter


Gord Dibben MS Excel MVP

On Mon, 4 Jan 2010 07:16:02 -0800, scavvie
wrote:

Trying to remove duplicates within one column can someone help