Delete rows with duplicate values
 

Hello,

I have a list of agents in row A (about 3000) and may of them are duplicate
values (sometimes the same agent name is there 5 or 6 times).

Can I do anything to delete the duplicate rows keeping only one row with the
value in question (formula, macro, etc.)???

Thanks!!!

Delete rows with duplicate values
 

A is a column, not a row.

Assuming you mean column A, select it then DataFilterAdvanced filter.

Check Unique records and copy to another place.

Delete everything that does not get selected. Those are the extras.


Gord Dibben MS Excel MVP

On Sun, 17 Feb 2008 10:41:02 -0800, One-Leg
wrote:

Hello,

I have a list of agents in row A (about 3000) and may of them are duplicate
values (sometimes the same agent name is there 5 or 6 times).

Can I do anything to delete the duplicate rows keeping only one row with the
value in question (formula, macro, etc.)???

Thanks!!!