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
留言
張貼留言