| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove duplicates from list but leaving one row with highest date
Hi Group,
I am trying to delete duplicate rows but leaving one row where it has the highest date. For example, I have 250 records in my list but manually removing duplicates I know that there are 175 unique records based on most recent date. I need to do this task very often. I have searched through previous postings but I can't find anything that meets my needs - can somehelp? Many thanks Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove all duplicates and return highest value in new row | Excel Discussion (Misc queries) | |||
| Remove duplicates found in master list | Excel Discussion (Misc queries) | |||
| 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
| How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions | |||
| How to delete rows with repeating values and leaving only one with highest value on the next column? | Excel Programming | |||
Threaded Mode
