Thanks so much this is exactly what I was looking for!

"Max" wrote:

One way which delivers exactly what you're after ..

Illustrated in this template:
http://www.flypicture.com/download/MTE1OTM=
Random assign 36 names to 4x9 n 3x12.xls

Source items assumed listed in A1:A36
In B1: =RAND()
In C1: =INDEX(A$1:A$36,RANK(B1,B$1:B$36))
Select B1:C1, copy down to C36

Now, set it up to extract from the randomized list in C1:C36
for the 2 desired groupings

Random 3 groups of 12 names
In F2: =OFFSET($C$1,ROW(A1)*12-12+COLUMN(A1)-1,)
Copy F2 across by 12 cols to Q2, fill down by 3 rows to Q4

Random 4 groups of 9 names
In F7: =OFFSET($C$1,ROW(A1)*9-9+COLUMN(A1)-1,)
Copy F7 across by 9 cols to N7, fill down by 4 rows to N10

Press F9 to regenerate ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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?