Duplicate lines in spreadsheet

Chip · Sep 25, 2009

I have a spreadsheet with approx 4,000 lines. There are duplicate items in
Column A. How can I eliminate the entire Row if there is a duplicate in
Column A ?? Thanks.

Gord Dibben · Sep 25, 2009

You want to keep one of each duplicate?

Select column A

Data>Filter>Advanced Filter>Unique records only and Copy to another
location.

Or see Chip Pearson's site for flagging duplicates for deletion.

http://www.cpearson.com/excel/Duplicates.aspx

Gord Dibben MS Excel MVP