excel中如何把0-9十个数字分别以5个组成一组,例如12345,23456,34567,45678用什么公式能做出来。

Question

如题所述

Answer 1

假设1~10在A1~A10单元格，A2输入公式：
=INDEX($A$1:$J$1,1,ROUND(RANDBETWEEN(1,10),1))&INDEX($A$1:$J$1,1,ROUND(RANDBETWEEN(1,10),1))&INDEX($A$1:$J$1,1,ROUND(RANDBETWEEN(1,10),1))&INDEX($A$1:$J$1,1,ROUND(RANDBETWEEN(1,10),1))&INDEX($A$1:$J$1,1,ROUND(RANDBETWEEN(1,10),1))
下拉

Answer 2

963852741的人现金付款一个恐怖和黄金分割线