ABCDEFGHIJKLMNOPQRSTUVWXYZ EXCEL中如何在这些字母中随机生成一列不重复的6位字母组合?不重复

2024-11-08 07:29:43
有1个网友回答
网友(1):

A1为字符串 "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
=MID($A$1,INT(RAND()*25+1),1)&MID($A$1,INT(RAND()*25+1),1)&MID($A$1,INT(RAND()*25+1),1)&MID($A$1,INT(RAND()*25+1),1)&MID($A$1,INT(RAND()*25+1),1)&MID($A$1,INT(RAND()*25+1),1)