On Aug 6, 3:58 pm, jt mwc wrote:
I have a list of 36 names, we would like to be able to generate lists of
randomly assigned groups such as 3 groups of 12 names or 4 groups
of 9 names, etc. Needs to be completely random assignments. Is
there a quick way to do this with excel 2003?

As a manual process, put =RAND() into the 36 cells of a column (or
row) adjacent to your data, select both columns (or rows), and click
on Data Sort to sort based on the column with RAND(). (Note: The
act of sorting will change all the values of the RAND() cells. No
matter; you don't really care what those values are.)

That randomizes the entire list of 36 names. Now, simply break them
into groups of whatever size you wish.

(You can also delete the column or row that contains the RAND()
values.)