Random Variable Generator

  • Thread starter Thread starter rowedf
  • Start date Start date
R

rowedf

I have been wondering if this is possible in Excel.

Example:

Say you want to put together a tournament. You have 30 names (
variable that is dynamic) and you want to seperate into random teams o
2 (another variable that can be dynamic). Would that be possible to d
in excel, generate random groupings within a list?

Thank

rowed
 
List the 30 names in a column. In the next column put the formula
=RAND() in each of the 30 rows. Select both columns and sort by the
random column. Each successive pair is then a team.

Jerry
 
Back
Top