Trying to highlight missing training from completed training

Hi

This is my 1st post.

This is what I'm trying to achieve and I would like to know how I can achieve it.

I want to produce a table of mandatory courses based on completed training to highlight the mandatory courses missing.

What I have
1 - Each department has a specific number of mandatory courses.
2 - I have the completed training courses data.

I want to know how I can generate a table of all Mandatory courses by department by employee so that it will tell me which employees are missing training. So the completed training would appear and just the missing training courses would be highlighted for each employee. I'm thinking there must be a master matrix giving the mandatory courses for each department. Please see the other tabs for a worked example.

See attached sample scenario.

I have to do this for 200 departments for 2000 employees.

Thanking you in advance.

CHRIS.

Hi Geoff

This is exactly what I'm looking for!

Thank you so much for your time, knowledge & experience in formulating the solution.

It will also push the boundaries of my Excel knowledge.

Kind regards

Chris