Any way to automate removal of older rows of data?

I have a spreadsheet with 4 columns: first name, last name, score and date.

I have people who are duplicated, some with the same date which I can easily remove with "remove duplicates" but I have examples where there are people with multiple rows from where they have taken a test a few years later, and i am trying to find a way to optimise my chopping up of this spreadsheet to only have a single row per user, and showing only their most recent score for the test.

The date column is dd/mm/yyyy and then a 24 hour format time stamp and I can't think of a good way to optimise that as it covers multiple years. Theres no good consistency over the old date and the most recent date

I imagine excel has some way of pruning older data. Atleast I hope so or ill have to check 50000+ rows manually to remove old results 😭