If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
remove all duplicates?
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 |
#2
|
|||
|
|||
remove all duplicates?
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 |
#3
|
|||
|
|||
remove all duplicates?
--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,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 haven’t participated in that course? I appreciate your help Regards Svetlana Wik |
#4
|
|||
|
|||
remove all duplicates?
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 haven’t participated in that course? I appreciate your help Regards Svetlana Wik |
Thread Tools | |
Display Modes | |
|
|