![]() |
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? |
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? |
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. |
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. |
All times are GMT +1. The time now is 01:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com