| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generate Random Number Table
Howdy,
I would like to generate a random number in a named range. The named range would have a variable size (up to 25000 row and 50 column). I know that I can copy/paste RND() in all the cells, but I am interested in generating the number. Using RND(), I would have to copy paste values so they would not change. I am also concerned about looping that many times and how long that would take. Is there an easy way to essentially populate a 2-D array from a random function? Regards, TB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In excel, I want to generate a random number | Excel Discussion (Misc queries) | |||
| Generate random number from a list | Excel Worksheet Functions | |||
| How do I generate only one random number without it refreshing? | Excel Worksheet Functions | |||
| generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
| GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE | Excel Discussion (Misc queries) | |||
Threaded Mode
