Posted to microsoft.public.excel.worksheet.functions

Colin[_4_] Colin[_4_] is offline

external usenet poster

Posts: 3

Formula for competition pairing

I have 20 teams who will each play 10 games against one of the other teams.
Can anyone please advise a formula that will match 10 pairs 5 times ensuring
that no team will play another team twice.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Competition Draw Table	Value increases with increase in font.[_2_]	Excel Discussion (Misc queries)	0	February 9th 09 01:33 PM
Competition Tables in Excel	Value increases with increase in font.[_2_]	Excel Discussion (Misc queries)	0	February 9th 09 01:30 PM
formula for pairing 60 different products into 5 price groups	B Thomas	Excel Worksheet Functions	1	January 19th 08 02:37 PM
Pairing Question	Chad	Excel Discussion (Misc queries)	0	March 21st 07 02:23 PM
World Cup Competition	SamTummo	Excel Discussion (Misc queries)	2	June 5th 06 05:09 PM

All times are GMT +1. The time now is 10:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us