Random Number Generator

[Guest]

I need to create a random number generator in Excel 2000 to fill one column
and about 3000 rows. How do I go about doing this?

 

[BenjieLop]

To generate a random whole number between 1 and 3000, you can use

=int(rand()*(3000-1)+1)

 

[Dave Peterson]

And if you need unique random numbers, J.E. McGimpsey has a userdefined function
that you could put in your range.

http://www.mcgimpsey.com/excel/udfs/randint.html

 

[Obbi]

Or you could use an add-in like zrandom to generate arbitrary larg
blocks of random numbers directly from an Excel menu.

http://www.zrandom.co