Extracting names not present in a sheet

Hello,

I have 2 sheets of data.

The first one contains a list of names of all employees in our company
The second contains a list of names of people who have attended training on a specific topic.

I would like to be able to extract from the 1st sheet the names of people who have NOT attended training, people who are basically not listed in the 2nd sheet. What formula or function should I use for this?

Regards
Crouz

Assuming the lists are in column A on both sheets, with a header row so that the data starts on row 2, you can put this formula in B2 of Sheet1:

=IFERROR(MATCH(A2,Sheet2!A:A,0),"absent")

Copy this down as required. You can then use a filter on column B to select all the "absent" names, and maybe copy them to another sheet.

Hope this helps.

Pete