random number generation

A

Ahmad

Dear all;
How I can generat 100000 random numbers using excel in one column, is
it possible.

thank you
 
N

Niek Otten

No, because the maximum number of cells in a column is 65536 at present. Excel 2007 (coming "soon") will have a million or so
rows.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Dear all;
| How I can generat 100000 random numbers using excel in one column, is
| it possible.
|
| thank you
|
 
L

Lori

Not unless you are using Excel 2007, as there are only 65536 rows. To
generate 100,000 random numbers in two columns, you could type
A1:B50000 in the name box nest to the formula bar and then type this
formula followed by Ctrl+Enter:

=RAND()
 
Top