random number generation

  • Thread starter Thread starter Ahmad
  • Start date Start date
A

Ahmad

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

thank you
 
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
|
 
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()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you randomly generate numbers in Excel 2007? 4
Randomizing 3
How can I sort a column of numbers generated by excel RAND funct? 5
Random Generator 15
Unique Random Numbers 5
Generate random numbers 3
Randomiser 3
Random Numbers 6

Back
Top