| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
random generate team
Appologize in advance if this question has been asked... but I want to use
Microsoft Excel to take a list of 25 names and create some random teams. See we have a B-Day party on Saturday and we are playing in a game that has two teams on a court at a given time with 5 players per team. We want to have a way to random generate the 5 teams. Any suggestions are greatly appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
random generate team
In a column alongside your names, put a random number =RAND().
Select both columns and sort by the second column. 1st 5 in one team, next 5 in 2nd team, etc. -- David Biddulph "Gary Shelton" wrote in message ... Appologize in advance if this question has been asked... but I want to use Microsoft Excel to take a list of 25 names and create some random teams. See we have a B-Day party on Saturday and we are playing in a game that has two teams on a court at a given time with 5 players per team. We want to have a way to random generate the 5 teams. Any suggestions are greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
| How would I pick random team players using a 1 to 5 rating sys? | Excel Worksheet Functions | |||
| How to generate random X given only min, max, mean? | Excel Discussion (Misc queries) | |||
| Random Team Generation | Excel Discussion (Misc queries) | |||
| generate random numbers | Excel Worksheet Functions | |||
Linear Mode
