| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting from a randomized list
Hello,
I suggest to select a vertical range of 30 cells and to array-enter: =RandInt(1,6,30,5) Or select a horizontal range of 30 cells and array-enter: =TRANSPOSE(RandInt(1,6,30,5)) My UDF RandInt you will find at http://sulprobil.com/html/randint.html With a sub calling my UDF you will have better control of (re-)calculating the random numbers. Regards, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a list in 1 cell by selecting an item from another list in | Excel Discussion (Misc queries) | |||
| Randomized Functions | Excel Discussion (Misc queries) | |||
| Randomized Paired Comparison Array | Excel Programming | |||
| Haw to Randomized available data | Excel Worksheet Functions | |||
| Populating a select group of cells with randomized names... | Excel Programming | |||
Hybrid Mode
