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