Find Duplicate ID, with newest start date, and mark old date to delete
I have a file which contains five fields:
I want to write a script that will find the unique student ID with the most current Start Date. Many of the student ID's are duplicated.
I can't use the counter and check duplicate calculation because it doesn't take in the date. I just don't know how to tell it to find the duplicate student ID with the most current date AND mark the other date to delete.
I have searched several of the duplicate posts and comments, but I just can't get it to do what I think it should.
Thank you in advance.