Index Not Working

[limo2088]

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

Master_Schedule Final10.xlsx
	A	B	C
2	Actual After Reductions In Cortex	DA Scheduled	Missing From "Cortex" Operations/Delivery Schedule
3	Andrew Lee Pickett	Andrew Lee Pickett	Andrew Lee Pickett
4	Anita Russell	Anita Russell	Colton Cyclle Starcher
5	Benjamin Kratky	Benjamin Kratky	Derrick Lamar Marshall
6	Colton Cyclle Starcher	Colton Cyclle Starcher	Jason Daniel Grace
7	Derrick Lamar Marshall	Derrick Lamar Marshall	Jeffrey Carl Othberg
8	Jason Daniel Grace	Jason Daniel Grace	John J Brown
9	Jeffrey Carl Othberg	Jeffrey Carl Othberg	Johnathan Terry McRae
10	Jessie Muheisien	Jessie Muheisien	Jonathon Andrew Honaker
11	John J Brown	John J Brown	LaMar LaRay Ware
12	Johnathan Terry McRae	Johnathan Terry McRae	LaShae Cherie Johnson
13	Jonathon Andrew Honaker	Jonathon Andrew Honaker	Lawrence Phillip Lambert
14	LaMar LaRay Ware	LaMar LaRay Ware	Patrick Dennis Connors
15	LaShae Cherie Johnson	LaShae Cherie Johnson	Quinton Demoine Clemons
16	Lauren Calloway	Lauren Calloway	Rodger Overfield II
17	Lawrence Phillip Lambert	Lawrence Phillip Lambert	Rubin francis Chappell
18	Marlesha Berry	Marlesha Berry	Travis Allen Snider
19	Patrick Dennis Connors	Patrick Dennis Connors
20	Quinton Demoine Clemons	Quinton Demoine Clemons
21	Rodger Overfield	Rodger Overfield II
22	Rubin francis Chappell	Rubin francis Chappell
23	Travis Allen Snider	Travis Allen Snider
24
25
Route Reductions 2

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))),"")

 

[BigBeachBananas]

I have a more straightforward approach that returns: Yes if Column A is in B, and No if Column A is not in B. However, this won't show the name, but I think you can filter on "NO" to get the list of people that were not scheduled from A.
Try in an empty column
=IF(COUNTIF(B:B,A1),"YES","NO")