EXCEL中,我想在一个单元格区域内产生N个随机数整数,这些随机整数不能重复!我试过rand函数和randbetween函数,但他们产生和结果都会有很多重复!急用!有意回答者,Private Sub 试算_Click()Dim seed,msg,tms
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/31 11:17:49
![EXCEL中,我想在一个单元格区域内产生N个随机数整数,这些随机整数不能重复!我试过rand函数和randbetween函数,但他们产生和结果都会有很多重复!急用!有意回答者,Private Sub 试算_Click()Dim seed,msg,tms](/uploads/image/z/8888348-20-8.jpg?t=EXCEL%E4%B8%AD%2C%E6%88%91%E6%83%B3%E5%9C%A8%E4%B8%80%E4%B8%AA%E5%8D%95%E5%85%83%E6%A0%BC%E5%8C%BA%E5%9F%9F%E5%86%85%E4%BA%A7%E7%94%9FN%E4%B8%AA%E9%9A%8F%E6%9C%BA%E6%95%B0%E6%95%B4%E6%95%B0%2C%E8%BF%99%E4%BA%9B%E9%9A%8F%E6%9C%BA%E6%95%B4%E6%95%B0%E4%B8%8D%E8%83%BD%E9%87%8D%E5%A4%8D%21%E6%88%91%E8%AF%95%E8%BF%87rand%E5%87%BD%E6%95%B0%E5%92%8Crandbetween%E5%87%BD%E6%95%B0%2C%E4%BD%86%E4%BB%96%E4%BB%AC%E4%BA%A7%E7%94%9F%E5%92%8C%E7%BB%93%E6%9E%9C%E9%83%BD%E4%BC%9A%E6%9C%89%E5%BE%88%E5%A4%9A%E9%87%8D%E5%A4%8D%21%E6%80%A5%E7%94%A8%21%E6%9C%89%E6%84%8F%E5%9B%9E%E7%AD%94%E8%80%85%2CPrivate+Sub+%E8%AF%95%E7%AE%97_Click%28%29Dim+seed%2Cmsg%2Ctms)
xUSWWV\L}$jΤN'NA]uSTC@4&Q$NBcL`Eݻ3N}ع|C_GhSBStZ-AndU߇IJkiQU|*#i\kN(׃ȭf3l ^deJRHRӈHh[ 2}]l/6ZL×tPep܃di_&?G" )gۿ?Dۨ4C9CSax{"l̑`,@xlH0䋈dBAeYC8z"m