Good Afternoon,
Here is my issue. I have been wrapping my brain around this for days and cannot for the life of me get it straight.
1. I have a list of names, trainings, and training dates.
2. Column A is for Name, Column B is for Completion Date, and Column C is for Training Name.
3. Each training type has its own separate row for each person resulting in have "Smith, John" having 7 different rows for 7 different trainings.
What I am trying to do is filter out all of the "Smith, John" rows if he is missing a specific training. In this case the training is labeled SST.
I want to do this for the entire sheet keeping only the names of the people who have NOT taken this SST training. I have attached an example of what I am working on.
Bookmarks