ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating a random number of arrays (https://www.excelbanter.com/excel-programming/317420-creating-random-number-arrays.html)

Sworkhard

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?

R.VENKATARAMAN

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?




Sworkhard

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.

Alex J

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