Removing Duplicate Values - 2 Columns

I have an excel file with 12,000 rows containing serial numbers and dates.

The serial numbers are duplicated throughout the sheet as they have multiple dates. How can I delete duplicate serial number values, but keep the latest date value?

I have attached an example excel file.

Thanks!