ExcelBanter - deduplication

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - deduplication (https://www.excelbanter.com/excel-discussion-misc-queries/252336-deduplication.html)

scavvie

deduplication

Trying to remove duplicates within one column can someone help

JMay

deduplication

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

Gord Dibben

deduplication

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

All times are GMT +1. The time now is 12:50 PM.