1,2,3,4组成随机的4位数，怎么用公式算出来？

a362901583

1,2,3,4组成类似1234,2134，包含这4个数字的4位数，可以用公式快速做出来？

asd2543997

=RANDBETWEEN(1,4)&RANDBETWEEN(1,4)&RANDBETWEEN(1,4)&RANDBETWEEN(1,4)

孤山月

=RANDBETWEEN(1,4)&RANDBETWEEN(1,4)&RANDBETWEEN(1,4)&RANDBETWEEN(1,4)

gykg-excel

=RANDBETWEEN(1000,4000)

a362901583

asd2543997 发表于 2017-9-23 14:08
=RANDBETWEEN(1,4)&RANDBETWEEN(1,4)&RANDBETWEEN(1,4)&RANDBETWEEN(1,4)

谢谢 真是感谢  那要是换成其他没规律的数字呢比如说 2.5 .6 .8  那这个又怎么写？是几个数就写几个&的内容？

scyss

a362901583 发表于 2017-9-23 14:23
谢谢 真是感谢  那要是换成其他没规律的数字呢比如说 2.5 .6 .8  那这个又怎么写？是几个数就写几个&的内 ...

=CHOOSE(RANDBETWEEN(1,4),2,4,6,8)&CHOOSE(RANDBETWEEN(1,4),2,4,6,8)&CHOOSE(RANDBETWEEN(1,4),2,4,6,8)&CHOOSE(RANDBETWEEN(1,4),2,4,6,8)

sucx007

香川裙子的vba代码，轻松搞定，自己百度

a362901583

asd2543997 发表于 2017-9-23 14:08
=RANDBETWEEN(1,4)&RANDBETWEEN(1,4)&RANDBETWEEN(1,4)&RANDBETWEEN(1,4)

谢谢 非常感谢

hcm19522

C2:H7{=IFERROR(INDEX($A:$A,LARGE(IF((COUNTIF($B2:B2,$A$2:$A$7)=0)*($A$2:$A$7<>""),ROW(A$2:A$7)),RANDBETWEEN(1,COUNTA($A$2:$A$7)+1-COLUMN(A1)))),"")

J2:J7=SUMPRODUCT(RANDBETWEEN(ROW($1:$4)^0,4)*10^{3;2;1;0})

C11:H11{=IFERROR(INDEX($A:$A,LARGE(IF((COUNTIF($B11:B11,$A$11:$A$16)=0)*($A$11:$A$16<>""),ROW(A$11:A$16)),RANDBETWEEN(1,COUNTA($A$11:$A$16)+1-COLUMN(A1)))),"")

J11:J16=C11&D11&E11&F11&G11&H11

L11:L16=TEXT(SUMPRODUCT(N(OFFSET(A$10,RANDBETWEEN(ROW(INDIRECT("1:"&COUNT(A$11:A$16)))^0,COUNT(A$11:A$16)),))*10^(COUNT(A$11:A$16)-ROW(INDIRECT("1:"&COUNT(A$11:A$16))))),"00000")