Comparison Function, Help Please.

[Mary K. Bullock]

Do you think this is possible?

I have a list of hundreds of candidate names on sheet 1 of a spreadsheet;
sheet 2 has the names of the people who attended an interview session. Is
there a formula that I can run that can compare sheet 1 with sheet 2 and
dump all of the names that are on sheet 1 but not on sheet 2 onto sheet 3?
(In other words, tell me which candidates have not yet interviewed?)

Thanks, in advance.

Katie

 

[Andy B]

Hi

Have a look here for some routines/formulas that should help:
http://www.cpearson.com/excel/duplicat.htm

 

[DDM]

Katie, please note that you received two good replies when you posted this
same question on 6/21, and at least one good reply (Andy b's) today. Let's
see if we can get you past square one. The formula below is based on the one
in Chip Pearson's website (see the reference in Andy b's reply, also in JE
McGimpsey's reply to your earlier post). It assumes that your sheet1 is
named Candidates and sheet2 is named Interviewed, that the names of those
interviewed are in A2:A50 of sheet2, and that the names of the candidates
begin in A2 of sheet1. This formula is array-entered, meaning press
Ctrl+Shift+Enter to enter it in Sheet3, Cell A2, then copy it down a number
of rows equal to the number of names on sheet1.

{=IF(COUNTIF(Interviewed!$A$2:$A$50,Candidates!A2)=0,Candidates!A2,"")}