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

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

--To remove duplicates check out the option from menu DataFilterAdvanced
FilterCopy to another location... Check 'Unique records only' (make sure
your data has got headers)

--If you have the employee names in ColA and ColD and aganist each ColA
entry you want to check whether they have participated in the course apply
this formula in ColB and copy down

=IF(COUNTIF(D:D,A1),"Participated","")

--
Jacob (MVP - Excel)


"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

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