排班 跳過不在公司 (12722)

I2{=MID(PHONETIC(B$2:B$9)&PHONETIC(B$2:B$9),MATCH(,0/ISNA(MATCH(B$2:B$9,IF((H2>=E$2:E$9)*(H2<=F$2:F$9),D$2:D$9,),))/(MOD(IFERROR(MATCH(I1,B:B,),1)-1,COUNTA(B:B)-1)+1<ROW($2:$9)),),1)