I5{=INDEX(B:B,SMALL(IF((C$2:G$9>0)*(C$1:G$1=J$1),ROW($2:$9),99),ROW(A1)))&""
J5=IF(I5="","",VLOOKUP(I5&"",B:G,MATCH(J$1,$1:$1,)-1,))
一公式I5:J5 下拉{=OFFSET($A$1,SMALL(IF(($C$2:$G$9>0)*($C$1:$G$1=$J$1),ROW($1:$8),99),ROW(A1)),(MATCH($J$1,$1:$1,)-1)^(B$1=$C$1))&""
留言
張貼留言