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?