D10:I23{=IFERROR(OFFSET($A$3,MOD(ROW(A2),2),SMALL(IF(($B$3:$B$4=$C10)*(800+INT(ROW(A2)/2)=$C$3:$X$4),COLUMN($C:$X)+CHOOSE(COLUMN(A1),0,1,1,0,1,1)),INT(COLUMN(C1)/3))),"")
E10改公式 下拉=IFERROR(INT(SMALL(IF(($B$3:$B$4=$C10)*(800+INT(ROW(B2)/2)=$C$3:$X$4),COLUMN($C:$X)+CHOOSE(COLUMN(B1),0,1,1,0,1,1)),INT(COLUMN(D1)/3))/3),"")
E10:E23複製到H10:H23
留言
張貼留言