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