random drawing
Posted by Cecil Pfeiffer on December 08, 2001 6:17 PM
How can i set up a work sheet to select six groups of four people at random, or any other groups ?
Like two groups of six,three groups of four, so on so on. Thank you
Posted by Aladin Akyurek on December 09, 2001 12:39 PM
Cecil --
One way:
Create a 2-column list where the first column consists of the series 1,2,3,...N and the second column of names (N is the number of people) in some sheet, select the range and name it e.g., PLIST via the Name Box.
Then enter in A1 in a diffrent sheet:
=RAND()
and copy down this till the Nth row (the number of people you have).
And in B1 enter and copy down:
=RANK(A1,$A$1:$A$24) [ A24 if N=24 ]
Use
=VLOOKUP(B1,PLIST,2,0)
and copy down. Partition the resulting list of names in chunks that suits your need.
Hope this helps.
Aladin
