remove all duplicates?

[snow]

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

 

[Bob Phillips]

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/art...-duplicate-data-with-Duplicate-Master-V2.html

 

[Jacob Skaria]

--To remove duplicates check out the option from menu Data>Filter>Advanced
Filter>Copy 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,A1),"Participated","")

 

[Ms-Exl-Learner]

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,"Participated","")))

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!