bobkap
Active Member
- Joined
- Nov 22, 2009
- Messages
- 313
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
I have many rows of data as shown below. How do I compare each row with the same name and keep the row with the most current date? In this example I need to keep row for Mary 2/20/2020 and delete the other row for Mary. Keep Bill's 4-5-2020 and delete the rest. Keep Sue's 7-22-2020 and delete the rest.