1-100随机组合成10个数一组的数字,数字之间重复率不超过30%,求EXCEL公...答:RANDBETWEEN(1,$A$2),"00")&"-"&TEXT(RANDBETWEEN(1,$A$2),"00")&"-"&TEXT(RANDBETWEEN(1,$A$2),"00")&"-"&TEXT(RANDBETWEEN(1,$A$2),"00")复制并下拉,即可得到随机的数据 若把A2单元格的数值改为100,即是1-100数值中的随机数了,但是有100时必须要把公式中的00改为000 ...