One way would be to put in a column say H the Rand() function for each row
with a name in column G. Then sort the list G:H using column H. Since
the Rand() function is volatile - everytime the worksheet is changed the
values are re-computed and repeated sorts will produce random lists. (Note:
The random function is not a random as you might think but for this purpose
it might suit you?)



--
Cheers
Nigel



"Greg" wrote in message
...
I would like to know how to get excel to make a random list of the names i
have in column g.

Is this possible?


Greg