My duplicate values are account numbers. I also have a date column sorted newest to oldest. I want to keep the three most recent duplicated account numbers based on the date, but remove any duplicate older than the first three. If I go to Data Tools > Remove Duplicates it removes all but the newest one. How can I remove all except the first three newest ones?
Attached is a sample of the data I am working with. Thanks.
duplicate sample.xlsx
Bookmarks