多組非空彙整一組 一組多格 (13270)

L2:N13{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(($C$2:$I$21<>"")*(MOD(COLUMN($A:$G),3)=1),ROW($2:$21)/1%+INT(COLUMN($A:$G)/3)/1%%+COLUMN(B:H)),ROW(A1)),4),"!R0C00"),),"")



留言