E3右拉 下拉{=OFFSET($A$1,SMALL(IF(FIND(MID($A$3:$A$13,2,1),"一二三四五")=INT(COLUMN(C1)/3),ROW($2:$12),99),ROW(A1)),MOD(COLUMN(C1),3))&""
O3:Q13{=INDEX(A:A,RIGHT(SMALL(FIND(MID($A$3:$A$13,2,1),"一二三四五")/1%+ROW($3:$13),ROW(A1)),2))
另解=LOOKUP(ROW(A1)-1,COUNTIF(OFFSET($A$2,,,ROW($1:200)),TEXT(INT(COLUMN(C:C)/3),"[dbnum1]三0班")),OFFSET($A$3:$A202,,MOD(COLUMN(C:C),3)))
留言
張貼留言