Remove duplicates but keep latest data

Hi everyone,

I have a spreadsheet list that has dozen of employees who have completed numbers of training on different dates, some did the same training multiple times because of validity/expiry dates. So removing duplicate employee, training, and completed date won't work because it will delete that specific employee's data.

Therefore, I would like to keep latest completed date data of duplicate training for each employee. If that makes sense. I have attached the spreadsheet for your review and to work. I am asking your advice and help cuz I dont possess the required knowledge and skills the accomplish this myself.

Thanks in advance, much appreciated!