How to manage duplicate entries with timestamp?

Hi Everyone,

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

is the table same size and position allways?
you could use delete rows and select duplicate rows but need to provide a range that excludes the timestamp column. in you case something like A1:D6 and in order to preserve the row with the newer timestamp use a sort range first on column E then delete rows on A1:D6