Comparison Function, Help Please.

  • Thread starter Thread starter Mary K. Bullock
  • Start date Start date
M

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
 
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,"")}
 
Back
Top