Thread: random pairings
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MJW[_3_] MJW[_3_] is offline
external usenet poster
 
Posts: 1
Default random pairings

I have a school "field day" to plan. I have 22 teams to participate at
13 stations. Obviously, some stations will have 2 teams at it at one
time. The simple way would be to just pair up 2 teams and rotate them
together at the same time. However I do NOT want the same teams to be
at the same stations all the time.

Is there a way I can create an excel worksheet to move a the teams
randomly through all the stations without the same teams bumping into
each other more than a couple times?

Thanks for any help.
(Note: I'm using Excel 2000)