Duplicate lines in spreadsheet

[Chip]

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]

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