mrxwanttobe
New Member
- Joined
- Apr 27, 2018
- Messages
- 23
- Office Version
- 2007
- Platform
- Windows
Hello all. Please note first column is a customer number and last column is a date. I want to remove all the duplicates but only keep the row with the most recent date so in my example only the row with the 01/11/20 date. Is this possible? Than you all in advance.
1962 | 40 | 40 | 7/8/16 22:29 |
1962 | 60 | 100 | 8/26/16 21:48 |
1962 | 100 | 100 | 10/13/17 22:32 |
1962 | 100 | 100 | 1/11/20 22:32 |
1962 | 40 | 40 | 11/2/18 22:51 |
1962 | 40 | 40 | 4/13/19 22:56 |