Creating a schedule / fairly for teams in excel

[tlhamilton]

Version: 2008 Operating System: Mac OS X 10.3 (Panther) I want to create a schedule for my golf league. Each girl will need to have a new partner every week with one bye week. What type of formula would work in Excell to do something like this? Is it possible at all?

 

[John McGhie]

See here:
http://www.teamopolis.com/tools/round-robin-generator.aspx

And here:
http://round-robin-formula.qarchive.org/

The Excel solutions out there require VBA, which you do not have in Excel
2008.

Hope this helps

Version: 2008 Operating System: Mac OS X 10.3 (Panther) I want to create a
schedule for my golf league. Each girl will need to have a new partner every
week with one bye week. What type of formula would work in Excell to do
something like this? Is it possible at all?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]