I have a large spreadsheet with names and dates. I need to be able to filter and keep only the latest 3 dates for each name and the rest can be deleted. If I it is not possible to delete them, if I could just highlight the latest 3 dates, that would suffice.... with the caveat that some names may only have 1 or 2 dates, which in that case, those would be left as is. Below is a small example of what I have and then what the outcome should be if possible. Any help or ideas would be greatly appreciated.
BEFORE:
Capture1.JPG
AFTER:
Capture2.JPG
Bookmarks