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?

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.)

Put the names in column A and =RAND() in column B.

Sort both columns by column B. Then just pick off the first three or the
first fourm etc.
--
Gary''s Student - gsnu200735


"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?

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?

http://www.flypicture.com/download/MTE1OTM=

In case you're having difficulties with the above link, just do a copy n
paste of the entire link (inclusive of the "=" at the end) into your
browser's address bar, press ENTER. That should give you the correct d/l
button at flypicture.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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?

Welcome. Great to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jt mwc" wrote in message
...
Thanks so much this is exactly what I was looking for!