Removing the oldest duplicate

[ajquinones]

Hi. I have a dataset that contains duplicate values, but also contains date values. I'd like to remove only the oldest duplicate and keep the most recent version. For example: 

Soccer	1/5/20
Baseball	1/9/20
Baseball	1/6/20
Soccer	1/20/20

In the above example dataset, I'd like to keep: 

Baseball	1/9/20
Soccer	1/20/20

Thank you! 

[DavidP · Accepted solution]

This is how I would do it

[AbhilashR · Accepted solution]

Hi @ajquinones, if you have more than one duplicate/date for a given item (i.e. soccer, baseball) the attached approach might help.

[ajquinones]

Thanks so much! 

[martinme8]

I used this method.