Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a random number of arrays
Is it possible to create a random number of arrays based on the names in a
range or array? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a random number of arrays
may be some more elegant solutions are there, meanwhile
you can allot a serial index to the names on the column left to names in another part create random numbers betwee the lowest and largest index numbers and then use vlookup funcion to get the names corresponding to the random numbers Sworkhard wrote in message ... Is it possible to create a random number of arrays based on the names in a range or array? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a random number of arrays
"Sworkhard" wrote: Is it possible to create a random number of arrays based on the names in a range or array? Actually, why do i ask this. I'll just create a 3d array instead. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a random number of arrays
Better still, create a collection of arrays.
APJ "Sworkhard" wrote in message ... "Sworkhard" wrote: Is it possible to create a random number of arrays based on the names in a range or array? Actually, why do i ask this. I'll just create a 3d array instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a random scheduler. | Excel Discussion (Misc queries) | |||
How can I match a random number with closest number from sequence? | Excel Worksheet Functions | |||
Creating a single vertical array from multiple column arrays | Excel Worksheet Functions | |||
Creating random passwords | Excel Worksheet Functions | |||
How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) |