Can anyone tell me why this formula isn't working correctly? Column C is supposed to tell me who is missing from Column B in column A. So for example Andrew Lee Picket is in both Column A & B, therefor he should not be showing as missing in Column C. At one point the formula was spot on but not sure what heppened. If its the type of formatting with the names. I am lost
Cell Formulas | ||
---|---|---|
Range | Formula | |
B3:B25 | B3 | ='Manual Morning Schedule'!B3 |
C3:C23 | C3 | =IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($B$3:$B$23)/(COUNTIF($A$3:$A$23,LEFT($B$3:$B$23,SEARCH(" ",$B$3:$B$23))&TRIM(RIGHT(SUBSTITUTE($B$3:$B$23," ",REPT(" ",100)),100)))=0),ROW(1:1))),"") |
C24:C25 | C24 | =IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($B$3:$B$70)/(COUNTIF($A$3:$A$30,LEFT($B$3:$B$70,SEARCH(" ",$B$3:$B$70))&TRIM(RIGHT(SUBSTITUTE($B$3:$B$70," ",REPT(" ",100)),100)))=0),ROW(22:22))),"") |