Removing duplicates from a list based on the latest date

Hello,

I need some help please.

I am working on a large data file (leasing file), that has many duplicates. The names on the file are duplicated due to the various variable costs associated with leasing.
I need to remove the duplicates names based on the latest contract end date.

Please see attached example of my file.

Many thanks in advance.