我们些活动,需要分给同学一些密码,用来限定参加活动的次数和人员。但是人数太多,我们要自己选择不重复的密码实在困难,所以想问下有没有哪些软件能够帮到我们的?
例如我们的每个密码都是前面3位为26个字母中任意三个,后面5位是0-9中任5个,他们出现次数不限。最好有可以多个密码一次选出的功能。
第1个回答 2011-07-03
用excel的随机函数就可以实现了啊。追问
请详细说明下步骤可以吗?
追答前三列输入=CHOOSE(MOD(INT(RAND()*1000),3)+1,"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"),后5列输入=INT(MOD(RAND()*10,10)),然后往下拉就可以了。
本回答被提问者采纳