Delete the oldest repeat

Hi Guys,

I have to monitor the training completion rates. Unfortunately, the reporting extract is less than ideal, with repeats etc.

The participants are meant to put their employee number in, but that doesn't always happen.

I'm looking for a way to manage this dynamic list (the number of records is likely to change)
I want to:

1. Delete anything in Column I that isn't "Passed"
2. Look for duplicates in Column G and for each duplicate, delete the oldest based on the value in column B
   • Delete the entire row of the oldest duplicate
   • Unfortunately, not all employee numbers are completed. I'm happy for a control column concatenating Column E and Column F instead

I've attached a sanitised workbook with two tabs - "Base Data" and "Intended Outomce"

• "Base Data" is indicative of how I would receive the data
• "Intended Outcome" is how I want it to look after the manipulation is complete

I would also be grateful if you could comment the life out of any VBA so I can read and, hopefully, learn.

Thanks all

MagicMan