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!
Solved! Go to Solution.
Hi @ajquinones, if you have more than one duplicate/date for a given item (i.e. soccer, baseball) the attached approach might help.
Thanks so much!
I used this method.