留守人員提取 (14137)

H2:J11=IFERROR(INDEX($1:$1,SMALL(IF(MMULT({1,1},N(T(OFFSET($A2,,{1,3,5;2,4,6}))="")),{2,4,6}),COLUMN(A1))),"-")

另解{=IFERROR(INDEX($1:$1,SMALL(IF(($B$1:$F$1<>"")*(($B2:$F2="")+($C2:$G2="")),COLUMN($B:$F)),COLUMN(A1))),"-")