Remember Me?

#1
November 30th 09, 09:10 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2007 Posts: 2
how to make a random rotation of 6 teams

How do I make a draw for 6 teams to play each other at 3 different locations

#2
November 30th 09, 10:21 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 11,058
how to make a random rotation of 6 teams

In C1 thru C6 enter:
=rand()

In A1 thru A3 enter:
=MATCH(LARGE(\$C\$1:\$C\$6,1),\$C\$1:\$C\$6,FALSE)
=MATCH(LARGE(\$C\$1:\$C\$6,2),\$C\$1:\$C\$6,FALSE)
=MATCH(LARGE(\$C\$1:\$C\$6,3),\$C\$1:\$C\$6,FALSE)

In B1 thru B3 enter:
=MATCH(LARGE(\$C\$1:\$C\$6,4),\$C\$1:\$C\$6,FALSE)
=MATCH(LARGE(\$C\$1:\$C\$6,5),\$C\$1:\$C\$6,FALSE)
=MATCH(LARGE(\$C\$1:\$C\$6,6),\$C\$1:\$C\$6,FALSE)

We see something like:

1 6 0.68334192
4 5 0.312318543
3 2 0.491735076
0.541504961
0.331550966
0.373367917

So at one match Team #1 plays Team #6
Team # 4 plays team # 5
Team # 3 plays Team # 2

You can create as many random pairings as you need simply by touching F9.
--
Gary''s Student - gsnu200909

"Rick Smith" wrote:

How do I make a draw for 6 teams to play each other at 3 different locations

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

 Similar Threads Thread Thread Starter Forum Replies Last Post wyobuff Excel Worksheet Functions 4 October 24th 08 06:19 AM Confused student Excel Discussion (Misc queries) 4 April 25th 08 04:12 PM Smeeg Excel Worksheet Functions 8 March 5th 06 01:30 AM chicken99 Excel Worksheet Functions 6 March 2nd 06 12:02 AM vegas Excel Discussion (Misc queries) 4 July 11th 05 11:03 AM

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