如何用EXCEL制作一组5000个,十位的,数字加字母的随机码(尽量不重复...答:RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))
请教EXCEL里随机码生成代码,共十位,包含字母大小写、数字(0、1除外...答:=CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(2,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(2,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(...
谁可以帮我用Excel生成随机数2000个 急用 ,最好是10位左右的字母加数字...答:64+RANDBETWEEN(1,26))&CHAR(64+RANDBETWEEN(1,26))&CHAR(64+RANDBETWEEN(1,26))&CHAR(64+RANDBETWEEN(1,26))&CHAR(64+RANDBETWEEN(1,26))&CHAR(64+RANDBETWEEN(1,26))&CHAR(64+RANDBETWEEN(1,26))&CHAR(64+RANDBETWEEN(1,26))&RANDBETWEEN(1,99)&RANDBETWEEN(1,99) ,公式下拉。