如题所述
输入以下公式,然后向下填充至125行,即可。
=OFFSET(A$1,INT((ROW(A1)-1)/25),)*100+OFFSET(A$1,MOD(INT((ROW(A1)-1)/5),5),)*10+OFFSET(A$1,MOD(ROW(A1)-1,5),)
详见附图
温馨提示:答案为网友推荐,仅供参考
第1个回答 2016-10-20
如果要是随机的话,用rand产生随机数,然后建立起和数字的对应关系,再做一个文字拼接或者数字拼接就可以了。如果想做遍历的全部显示,可能就会麻烦一些了
第2个回答 2016-10-21
a1到a5放你的5个数;
b1填入=RANDBETWEEN(1,5)
b2填入=IF(B1>1,RANDBETWEEN(1,B1-1),RANDBETWEEN(2,5))
b3填入=IF(B1=1,IF(B2=2,RANDBETWEEN(3,5),RANDBETWEEN(2,B2-1)),IF(B1<5,RANDBETWEEN(B1+1,5),IF(B2<4,RANDBETWEEN(B2+1,4),RANDBETWEEN(1,3))))
c1填入=1,c2填入=10,c3填入=100,
d1填入=RANDBETWEEN(1,3)
d2填入=IF(D1=1,CHOOSE(RANDBETWEEN(1,2),2,3),IF(D1=2,CHOOSE(RANDBETWEEN(1,2),1,3),CHOOSE(RANDBETWEEN(1,2),1,2)))
d3填入=6-D1-D2
e1填入=INDIRECT("a"&B1)*INDIRECT("c"&D1)+INDIRECT("a"&B2)*INDIRECT("c"&D2)+INDIRECT("a"&B3)*INDIRECT("c"&D3)
e1就是结果了追问
b1填入=RANDBETWEEN(1,5)
b2填入=IF(B1>1,RANDBETWEEN(1,B1-1),RANDBETWEEN(2,5))
b3填入=IF(B1=1,IF(B2=2,RANDBETWEEN(3,5),RANDBETWEEN(2,B2-1)),IF(B1<5,RANDBETWEEN(B1+1,5),IF(B2<4,RANDBETWEEN(B2+1,4),RANDBETWEEN(1,3))))
c1填入=1,c2填入=10,c3填入=100,
d1填入=RANDBETWEEN(1,3)
d2填入=IF(D1=1,CHOOSE(RANDBETWEEN(1,2),2,3),IF(D1=2,CHOOSE(RANDBETWEEN(1,2),1,3),CHOOSE(RANDBETWEEN(1,2),1,2)))
d3填入=6-D1-D2
e1填入=INDIRECT("a"&B1)*INDIRECT("c"&D1)+INDIRECT("a"&B2)*INDIRECT("c"&D2)+INDIRECT("a"&B3)*INDIRECT("c"&D3)
e1就是结果了追问
这种描述,能看懂吗!能做吗?