
excel
根据您的需求,我可以为您提供以下解决方案:对于
excel 2007版:在A2单元格中输入以下公式:((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND()
在excel 2003版本中,您可以使用以下公式来实现同样的效果:在A2单元格中输入以下公式:((35-ROW())*RAND()((35-ROW())*RAND()
同时按下Ctrl+Shift+Enter键输入数组公式。然后,使用自动填充柄将以下公式填入A$1:A$33单元格中:在A$1:A$33单元格中输入以下公式:((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()
这样,您就可以生成随机数填充32行了。请注意,在excel 2007版本中使用上述公式时,需要确保A1单元格中不输入任何数字或文本,否则会导致错误。