Filter duplicate values by latest date

[RDF25087]

Help!

I have a dataset that contains duplicated serial numbers:

Registered Date	Serial Number
08/11/2023	1234
06/11/2023	1234
06/11/2023	1234
14/11/2023	7890
17/11/2023	7890

I need to only keep the rows with the latest registered date. So for the above example, I'd like the data cleansed to extract only the following:

Registered Date	Serial Number
08/11/2023	1234
17/11/2023	7890

Any help would be greatly appreciated.

Thanks

RDF

[alexnajm]

Sounds like a Summarize tool!

[TimN]

Just sort and then use a unique tool...

Note date sorted in descending order