Creating a random number of arrays

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create a random number of arrays based on the names in a
range or array?
 
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 said:
Is it possible to create a random number of arrays based on the names in a
range or array?
Click to expand...

Actually, why do i ask this. I'll just create a 3d array instead.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select random records by two conditions 1
random number generation help 3
Six columns randon no.'s no dupes 6
Array Randomly Sorted 4
How to read Excel Array to vb.net Arrays? 20
Search an array of sheets for an array of numbers & return count of numbers 11
vba array logic 3
Randomly choose x numbers from y data block 5

Back
Top