| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing duplicates but leaving data on following rows
Hi
I am hoping someone might have a VBA solution for this I have the following list in excel 12345 14/07/2009 12345 15/07/2009 12345 28/07/2009 35687 17/07/2009 35687 18/07/2009 35687 19/07/2009 23658 20/07/2009 23658 21/07/2009 The first Column is Col A and the second i Col B. I would like to remove duplicates from Column A to be left with the following 12345 14/07/2009 15/07/2009 28/07/2009 35687 17/07/2009 18/07/2009 19/07/2009 23658 20/07/2009 21/07/2009 Thereby keeping the first incidence of the number. Column B is not always dates it may sometimes be Surnames. I would be grateful for any help on this. Eddie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete all dulplicate rows leaving no record of the duplicates | Excel Discussion (Misc queries) | |||
| delete a duplicate in column while leaving other duplicates | Excel Worksheet Functions | |||
| Sorting a collection. *Leaving Duplicates* | Excel Programming | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Scanning for Duplicate Data in a Column, Merging Data and Finally Removing All Duplicates...? | Excel Programming | |||
Threaded Mode
