Forum Discussion
Solved
A unique de-dupe challenge..
Dear Excel Community, I have a unique de-dupe challenge: I need to find all the duplicate values in the ID column and then look at the date column and remove all the duplicate rows EXCEPT the row with the most recent date. So the end result will be: all unique values that were already there + the most recent dated duplicate values. See the attached sample file and let me know your expert thoughts on the best script or formula approach that can accomplish this. The actual spreadsheet will have over 1000 rows - so I don't want to crash Excel either 😄
A relatively easy way to do this:
- Sort the data by ID and Date (newest to oldest on the latter).
- On the Data tab of the ribbon, select Remove Duplicates.
Clear the check boxes for all columns except ID
Click OK.
- Sort the data by ID and Date (newest to oldest on the latter).
2 Replies
A relatively easy way to do this:
- Sort the data by ID and Date (newest to oldest on the latter).
- On the Data tab of the ribbon, select Remove Duplicates.
Clear the check boxes for all columns except ID
Click OK.
Worked perfectly. HansVogelaar, you're the man! Thank you!
- Sort the data by ID and Date (newest to oldest on the latter).
