| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete the rows of the duplicates in a column, keep single entries only
This is a lot trickier than I thought at first.
In column A, text or values not a result of formulas: aaa bbb ccc xxx a12 b12 c12 yyy aaa bbb ccc a12 zzz b12 c12 Delete entire row of the duplicated entries. After code has run on column A: xxx yyy zzz Produces a list (keeps the associated row) of single entry items only, others and their row are deleted. Thanks, Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if row has duplicates, concat entries in another column? | Excel Discussion (Misc queries) | |||
| Find duplicates, sum column then delete duplicates | Excel Programming | |||
| find duplicates between rows, keep or delete entries based on ranked relevance | Excel Programming | |||
| Search Column - Find Multiple Entries - Sum Then Delete to Single Entry | Excel Programming | |||
| I want to delete rows with duplicate entries within one column. | Excel Discussion (Misc queries) | |||
Threaded Mode
