Comparing 2 Sheet without Unique Value

[Zlatan09]

Hello,
I would just like to start by saying this is an amazing place that I stumbled upon when searching for a solution for my problem.
My Problem...
I run a report every month to identify employees who completed assigned training for my location. What is inconvenient is trying to find the people that have not completed the training. The problem is the report does not have a unique ID therefore I can't run use Vlookup.On the first sheet, I will have a master list of all the employees' first and last name + their departments. On the second sheet, I will plugin the result of who completed the training. on the 3rd sheet, I need to find a way to show who is missing from the original sheet.
Thank you for your help in advance.

 

[queuesmef]

2 options: 1. Create a unique id for EEs. Perhaps a combination of 1st 4 chars of last name and 1st 2 chars of first name. then you could have a Common/Vlookup~able field.
2. put info in Pivot table. for EE Master List: have headings for: minimally have LastName, FirstNameand Table1(for EEs) ~ for the ClassesTaken Have all info you need and make sure there is LastName & FirstName and Table2. I place them all in a Pivot Table. See Picture below