I am looking for ways to manage this problem.
I have an excel containing duplicate data. I want to remove the duplicate data and retain only the row with the latest timestamp.
Please refer on the data below:
As you can see the data have 2 entries fro Andro Carlo
I want to remove the data row with timestamp of 2/27/2021 16:44 and retain the 2/27/2021 16:50
Thanks and Advance