B2=IF(MOD(INT((ROW(A1)-1)/D$2),2),B1-(MOD(ROW(A1)-1,D$2)>0),MOD(ROW(A1)-1,D$2)+1)
可第一行開始=TEXT(MOD(INT((ROW(A1)-1)/D$2),2)*(D$2-MOD(ROW(A1)-1,D$2)),"0;;"&MOD(ROW(A1)-1,D$2)+1)*1
可第一行開始{=ABS(SMALL(ROW(INDIRECT("1:"&D$2))*-1^MOD(INT((ROW(A1)-1)/D$2),2),MOD(ROW(A1)-1,D$2)+1))
留言
張貼留言