Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete duplicate rows | Excel Worksheet Functions | |||
Delete duplicate values | Excel Discussion (Misc queries) | |||
Delete rows with duplicate values | Excel Worksheet Functions | |||
How do I delete both duplicate rows from a spreadsheet? | Excel Discussion (Misc queries) | |||
Function to find duplicate values, then delete | Excel Worksheet Functions |