Howdy,

I am responsible for an Excel training log at my work. The contents are as follows:

"Personnel": This worksheet has an alphabetized list of all personnel and their shifts, one name per row.
"Training": This is a list of which trainings each employee has completed with the columns set-up as follows: Name/Shift/Training/Date; A:D, respectively.

The names and shifts in columns A & B are validated from the list in the "Personnel" sheet, while the trainings are validated from a hidden list in the "Trainings" sheet. The date is entered manually. This means you can have several rows with the same employee, but different trainings. Data for new trainings are entered in the next empty row. Subsequently, columns A:D are formated as a List (from the Data menu) for ease of analysis.

Here's the problem: I have been asked to create a consolidated list of employees who have completed "Training A" but not "Training B". Basically, a single column of names that meet that criteria. This has proved to be harder that it looks, especially since the "Trainings" sheet is not static.

Any ideas?

Thanks,
AKQJ10