E2:H12{=IF(($D2=$A$2)*ISNUMBER(FIND(E$1,"BDEF")),"V",IFERROR(INDEX($A:$A,MATCH(E$1,IF({1,0},INDEX($E$1:$L$1,MOD(MATCH($B$1,$E$1:$L$1,)-2+ROW(B1),8)+1),IF(OR(MOD(MATCH($B$1,$E$1:$L$1,)-2+ROW(A1),8)+1={1,3,7,8}),MID("BDEF",MOD(FIND($B$2,"BDEF")-1+COUNTIF($E$1:$L1,$A$2),4)+1,1),"")),)),""))
留言
張貼留言