View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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?