You could use Advanced filter which has a Unique Values option, or if it is
more complex then Dave Brett has an addin for doing this

http://www.experts-exchange.com/arti...Master-V2.html

--

HTH

Bob

"snow" wrote in message
...
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 haven't participated in that course?

I appreciate your help

Regards Svetlana Wik