Need help on selecting data within multiple ranges based on the date of the record.
I have a list of 12,155 records. Within this list, there are actually 4000 unique names ordered by ID, i.e., John Smith has the ID of 2, Joe Sanders has the ID of 3, etc.
Each line has a date.
Within each ID range, I would like to be able to select the most recent record, i.e., John Smith 7/28/2023 instead of John Smith 7/28/2017.
I have attached a sample.
What could be the solution?
Thank you.
Attachment 837946Sample Data (1).xlsx
Bookmarks