Assume that the first column consist the Column Headers and the A Column is
having the Employee Names and the C Column is having the Participated
Employee Names.

Copy and paste the below formula in B2 cell
=IF(A2="","",IF(ISNA(VLOOKUP(A2,C:C,1,FALSE)),"Not
Participated",IF(VLOOKUP(A2,C:C,1,FALSE)=A2,"Parti cipated","")))

Drag the B2 cell formula to the remaining cells of B Column based on the A
Column Data.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"snow" wrote:

Hey.

I have office 2003. Was wondering how do you remove all duplicates?

I have a column with the names of the employees, and another column with the
names of those who have participated in a course. How/ what formula shall I
use to find out who havent participated in that course?

I appreciate your help

Regards Svetlana Wik