generate randomly assigned lists

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" <jtmwc.TakeThisOut@discussions.microsoft.com> wrote in message
news:453C6011-5424-4F49-A9DA-BABCEC3FE761@microsoft.com...
> Thanks so much this is exactly what I was looking for!