...从每一组中取出一个数进行组合,怎样能快速用EXCel实现?
http://zhidao.baidu.com/question/203245067.html?fr=iks&word=excel+%B1%ED%B8%F1%B5%C4%CE%CA%CC%E2%2C%CE%D2%D3%D016%D7%E9%CA%FD%BE%DD%2C%C3%BF%D7%E97%B8%F6%CA%FD%D7%D6%2C%D3%D0%C4%C7%D0%A9%D7%E9%D7%E9%BA%CF%2C%D6%D8%B8%B4%D6%B5%D3%D06%B8%F6&ie=gbk ——百度知道
-
答:输入公式:=INDIRECT(ADDRESS({1,2,3},INT(RAND()*7+1)))CTRL+SHIFT+ENTER结束 用这个方法,可以生成多组随机数,比如选择A5:C8,同样使用联合数组得到4组随机值 按F9刷新,得到完全不重复的组合为止 ...