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.
19 freelancers are bidding on average $18 for this job
With my experience it should not be a problem to do such thing. Relevant Skills and Experience I have written macros for reporting in my current job Proposed Milestones $15 USD - Creating the macro