在excel随机生成六位数数字答:说明:第一位,不能出现0,3,4,所以用公式:choose(1+int(7*rand()),1,2,5,6,7,8,9)产生除0,3,4的数,其它5位不能出现3,4,于是用公式:choose(1+int(8*rand()),0,1,2,5,6,7,8,9)产生除3,4的数.最后合并.为了使合并出的随机6位文本型的数转化成数值型,用了一个value函数.
excel6个数随机组合,不重复。答:在a1-a6 输入 =RANDBETWEEN(1,6)在目标单元格输入 =CONCATENATE(A1," ",A2," ",A3," ",A4," ",A5," ",A6)按F9使目标单元格随机得出你想要的6个数为止