Comparing two columns of data and returning the values that do NOT appear in both columns

Hello,

Thanks for the welcoming e-mail.

I have an attendance sheet that employees scan their badge number, and returns their name and time/date stamp using a simple VLOOKUP.

I want to create a report that compares the names in the attendance sheet against the all the names in the master sheet, and only returns the names that have not attended the training.

I have tried a few test formulas using COUNTIF function, but with no luck.

I have attached an example. Use the worksheet labeled April 2014 A (2nd shift)

Thanks in advance for your ideas!

Thank you! I learned something new! However, I am still having trouble with a solution. Your example only works if the same employee name that attended the training is in the same row in your master sheet. In reality, employees will never scan in their badges in alphabetical order. In other words, the name listing in Column B will not match the name listing in Column F. I was hoping for a solution that can cross reference the listing of Column B against Column F, and return ONLY the names that do not appear in both columns. If you have another idea for this, I would be grateful.

Jason