用EXCEL随机生成6-8位字母组合
=INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))
虽然有点长,但你可以看出是六位随机数并成的,如仍觉长,可以将10位数字,26*2个字母定义为一个区域,我这儿是一步到位
是如图意思吗?
=LEFT(CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(8,16))
输入
=CHAR(INT(RAND()*24)+97)&CHAR(INT(RAND()*24)+97)&CHAR(INT(RAND()*24)+97)&CHAR(INT(RAND()*24)+97)&CHAR(INT(RAND()*24)+97)&CHAR(INT(RAND()*24)+97)&CHOOSE(RANDBETWEEN(1,2),"",CHAR(INT(RAND()*24)+97))&CHOOSE(RANDBETWEEN(1,2),"",CHAR(INT(RAND()*24)+97))
得到6个随机小写字母,外加两个随机可能出现的小写字母或空格。
每位字母可按以下函数生成:
=HLOOKUP(RANDBETWEEN(1,26),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,21,22,23,24,25,26;"a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","u","v","w","x","y","z"},2)
然后用连接函数将各字母连接起来就行了。
建立一个宏,代码是
i = Round(Rnd() * 2) + 6
s = ""
For j = 1 To i
s = s & Chr(Round(Rnd() * 25) + 97)
Next
MsgBox s
用RAND函数
excel怎么生成随机数
在Excel中,有rand()函数可以生成随机数,只不过生成的范围是0-1之间。我们可以使用int来使随机数强制转换成整数,下面是随机生成2位数以及2位以上的数的方法。2位数n,则10=<n<=99,公式为"=INT(RAND()*90+10)"3位数为 "=INT(RAND()*900+100)"...6位数为"=INT(RAND()*900000+100000)...
excel中如何生成随机小数字?
工具\/原料:联想Y7000P Windows10 Microsoft Excel 2016 1、首先,在Excel中选择要生成随机数的一个区域,如下图所示,在此区域中生成10-100之间带有两位小数的随机数字。2、Excel中利用Randbetween函数可以生成指定范围内的整数,要生成小数,只要先生成整数,然后除以10的倍数即可。因此在Excel中输入公式=...
运用Excel生成随机数表并进行随机抽样
批量生成随机数表 一旦掌握了这个技巧,复制就变得简单。只需将生成的随机数拖动到所需的单元格,一列列、一行行地扩展,你就可以轻松构建出一张随机数表,满足任何抽样需求。无论是市场调查、数据分析还是游戏设计,Excel的随机数功能都能助你一臂之力。在Excel的世界里,每一个数字都带着一丝随机的...
如何在excel中随机生成数据
1、以下表为例,需要表格中随机生成50-100之间的随机数据。2、首先选中需要生成随机区域的单元格,选中后单元格会变成灰色。3、依次执行公式—插入函数。4、再插入函数面板类别选择数学与三角函数、randbetween后点击确定。5、在bottom(最小值)中输入50,在top(最大值)中输入100,点击确定。6、返回...
excel怎么随机生成一个数
1、演示使用的办公软件office Excel,软件的版本为office家庭和学生版2016,其他版本的office或WPS表格可以参考本操作。2、根据问题描述,我们在a1单元格中输入一个固定值。3、然后我们在任意一个单元格内输入得到随机值的函数,“=RAND()*24000-12000”,该函数产生的数值范围为-12000~+12000之间。4、...
excel 如何随机生成不重复的10个数
那就对1-10这10个数随机排序,然后随机赋给相应的单元格。 bqllda | 发布于2009-03-22 举报| 评论 0 0 =ROUND(1,10) shibuditou658 | 发布于2009-03-22 举报| 评论 0 0 其他2条回答 为您推荐: excel随机生成小数 excel函数公式大全 excel求和 excel随机数发生器 vba生成随机数不重复 ...
如何用Excel生成随机数?
可以利用迭代计算来解决这个问题,本文以用公式生成10个和值为1000,且范围在80-120之间的随机整数为例,说明Excel中用迭代计算的解决方法。1.启用迭代计算。在Excel2013中,单击“文件→选项→公式”,勾选“启用迭代计算”,根据实际需要调整“最多迭代次数”数量,本例为默认的“100”,将“误差”设...
如何在excel中随机生成数据
Excel中可以利用rand函数或者randbetween函数来实现随机生成数据。软件版本:Office2013 以Randbetween函数为例说明,方法如下:1.在A1-A10中随机生成1-100之间的数字,输入公式如下:2.下拉填充得到结果:注意事项:这些数字不是固定的,每次任意单元格更新或者按下F9,随机数字都会变化 ...
excel怎么在某一范围内生成随机数?
详情请查看视频回答
如何用EXCEL表格随机生成方程式?
首先,在EXCEL表格中设置两个单元格(例如A1和A2),每个单元格中都填写公式"=RAND()"。在另一个单元格(例如A3)中,使用简单的算术运算符生成随机方程式,例如"=A1+A2"。重复步骤2,生成更多的随机方程式。如果要生成整数方程式,可以使用ROUND函数,例如"=ROUND(A1+A2)"。请注意,这仅是一种简单...
柘哀玉液: =INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,...
小店区17147906364: EXCEL中如何随机生成一列6位数字和字母组合.请高手列出公式 和详细使用方法,谢谢.我是小白?
柘哀玉液: 给你一个简单易懂的,只是长了一些,但已经是最好懂的了.解释在最下面. =MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",INT(RAND()*36)+1,1) 这会返回一个随机的数字或字母 =MID("0123456789...
小店区17147906364: 如何在EXCEL中随机函数26个英文字母? - ?
柘哀玉液: 大写字母 =CHAR(RAND()*26+65) 小写字母 =CHAR(RAND()*26+97)笨一点的公式就是 大写字母 =LEFT(ADDRESS(1,RAND()*25+1,4)) 小写字母 =LOWER(LEFT(ADDRESS(1,RAND()*25+1,4)))
小店区17147906364: 如何用Excel批量生成6位大写字母+数字的随机字符??
柘哀玉液: 需要用到几个函数 生成大写字母可以用CHAR()函数,A-Z对定的参数是65-90 比如CHAR(65)="A",CHAR(90)="Z" 生成65-90之间的随机整数可以用RANDBETWEEN(65,90) 把数字和字母组合成一个字符串可以用"&" 你可以根据你的需要灵活应用这几个函数 A1-A100: ="A"&RANDBETWEEN(1,100) A-Z: =CHAR(RANDBETWEEN(65,90))
小店区17147906364: EXCEL中如何随机生成一列20位数字和字母组合.请高手列出公式 和详细使用方法,谢谢.我是小白?
柘哀玉液: 鼠标点击输入框,闭上你的双眼,手指轻轻放在键盘上,随机按,那样就随机生成数字与字母了.(按的时候,心里要计算按了20次)
小店区17147906364: excel随机产生6位字符,其中要包含2个数字4个字母(小写的吧) - ?
柘哀玉液: 随机产生大写英文字母 =CHAR(INT(RAND()*24)+65) 随机产生小写英文字母 =CHAR(INT(RAND()*24)+97)随机产生大小写英文字母 =CHAR(INT(RAND()*24)+if(INT(RAND()*2)=0,65,97))或者编段程序: 按ALT+F11组合键,调出VBA窗口,插入...
小店区17147906364: excel生成7位数字一位字母的随机码 - ?
柘哀玉液: =REPLACE(RIGHT(INT(RAND()*1000000000),8),INT(RAND()*7),1,CHAR(RANDBETWEEN(65,90))) 你用这个试试 步骤是这样的,先取一个10位的联机数字 从右选取数字的8位 在8位数字中,随机位置Replace一位字母 字母的随机取值可以用...
小店区17147906364: 如何在EXCEL中生成八位数的大写字母加数字的随机字符串? - ?
柘哀玉液: 展开全部=CONCATENATE(LOOKUP(RANDBETWEEN(1,31),{1,"A";2,"B";3,"C";4,"D";5,"E";6,"F";7,"G";8,"H";9,"I";10,"J";11,"K";12,"L";13,"M";14,"N";15,"P";16,"Q";17,"R";18,"S";19,"T";20,"U...
小店区17147906364: ABCDEFGHIJKLMNOPQRSTUVWXYZ EXCEL中如何在这些字母中随机生成一列不重复的6位字母组合?不重复 - ?
柘哀玉液: A1为字符串 "ABCDEFGHIJKLMNOPQRSTUVWXYZ"=MID($A$1,INT(RAND()*25+1),1)&MID($A$1,INT(RAND()*25+1),1)...
小店区17147906364: 哥,怎么在EXCEL中生成八个字的英文随机字母 - ?
柘哀玉液: =CHAR(INT(RAND()*(122-97+1)+97)) 以上是生成一个的公式