=IF(MOD(ROW(A1),6)=1,100+ROUNDUP(ROW(A10)/6,0),”“)excel每隔6行加1,6行之间为上一个数:
=IF(MOD(ROW(A1),6)=1,101+ROUNDUP(ROW(A6)/6,0),100+ROUNDUP(ROW(A6)/6,0))
效果如下:
101
101
101
101
101
101
102
102
102
102
102
102
103
103
103
103
103
103
104
104
104
104
104
104
105