| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
random number generation
Dear all;
How I can generat 100000 random numbers using excel in one column, is it possible. thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
random number generation
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 "Ahmad" wrote in message ups.com... | Dear all; | How I can generat 100000 random numbers using excel in one column, is | it possible. | | thank you | |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
random number generation
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() Ahmad wrote: Dear all; How I can generat 100000 random numbers using excel in one column, is it possible. thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
random number generation
No I am using office 2003
Niek Otten yazdi: 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 "Ahmad" wrote in message ups.com... | Dear all; | How I can generat 100000 random numbers using excel in one column, is | it possible. | | thank you | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| random number | Excel Discussion (Misc queries) | |||
| Random Number response | Excel Worksheet Functions | |||
| generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
| random number with text | Excel Worksheet Functions | |||
| Random Number Questions | Excel Worksheet Functions | |||
Linear Mode
