編排架号 (10096)

D2=IF(A2="","",RIGHT(0&INT((ROW(A1)-1)/24)+1&MOD(INT((ROW(A1)-1)/4),6)+1&MOD(ROW(A1)-1,4)+1,4))

另解=IF(A2="","",RIGHT(0&SUM((MOD(INT((ROW(A1)-1)/{24,4,1}),{99,6,4})+1)*{100,10,1}),4))