排列 隔指定數 (15141)

B4:U6{=RIGHT(SMALL(MOD($B$1:$U$1-1,ROW(A1)*2-(ROW(A1)=3))/1%+$B$1:$U$1,COLUMN(A1)),2)*1

另解B4:U6{=RIGHT(SMALL(MOD($B$1:$U$1-1,CHOOSE(ROW(A1),2,4,5))/1%+$B$1:$U$1,COLUMN(A1)),2)*1

B4:U6格式化=MOD(MOD(B4-1,CHOOSE(ROW(A1),2,4,5)),2)

B9:U13{=RIGHT(SMALL(MOD($B$1:$U$1-1,$A9)/1%+$B$1:$U$1,COLUMN(A1)),2)*1



留言