不难。式子有点长，你试试这个公式：
=HLOOKUP(MOD(INT(ROW(A900)/900),900),{0,1,2,3,4,5,6,7,8,9;0,1,2,3,5,6,7,8,9,0},2,)&HLOOKUP(MOD(INT(ROW(A90)/90),90),{0,1,2,3,4,5,6,7,8,9;0,1,2,3,5,6,7,8,9,0},2,)&HLOOKUP(MOD(INT(ROW(A9)/9),9),{0,1,2,3,4,5,6,7,8,9;0,1,2,3,5,6,7,8,9,0},2,)&HLOOKUP(MOD(ROW(A9),9),{0,1,2,3,4,5,6,7,8,9;0,1,2,3,5,6,7,8,9,0},2,)
