Can anything be done with the fact that the names dont match exactly? So I have a formula which compares Column B with Column A, But as you can see some of the names dont exacly match. They have a middle name or a middle initial. Is there any way to circumvent this? Maybe just use the last name as a verifier.
Cell Formulas | ||
---|---|---|
Range | Formula | |
B3:B22 | B3 | ='Manual Morning Schedule'!B3 |
C3 | C3 | =IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW(B$3:B$50)/ISNA(MATCH(B$3:B$50,A$3:A$50,0)),ROWS(C$3:C3))),"") |
C4:C22 | C4 | =IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW(B$3:B$26)/ISNA(MATCH(B$3:B$26,A$3:A$23,0)),ROWS(C$3:C4))),"") |