remove all duplicates?

  • Thread starter Thread starter snow
  • Start date Start date
S

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
 
--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:D,A1),"Participated","")
 
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!
 
Back
Top