A simple macro required to format an existing table.
* Keep unique records
* Unique records "Project" & "Grade" column should be based on the latest "Ending Date"- based on the badge id.
* Unique records "Starting Date" should be the oldest amongst the duplicated records of the specific badge id.
* Unique records "Ending Date" should be the Newest Date amongst the duplicated records of the specific badge id.
Please find attached sample workbook.
Provide a sample macro and you will be awarded the project upon submission.