If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 how to make a random rotation of 6 teams
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## how to make a random rotation of 6 teams

#1
November 30th 09, 09:10 AM posted to microsoft.public.excel.misc
 Rick Smith external usenet poster 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
 Gary''s Student external usenet poster 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

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post How to make random numbers stay the same wyobuff Excel Worksheet Functions 4 October 24th 08 06:19 AM How do I make a random sample? Confused student Excel Discussion (Misc queries) 4 April 25th 08 04:12 PM Random numbers to make a known amount Smeeg Excel Worksheet Functions 8 March 5th 06 01:30 AM How can I make the rows go into a random order? chicken99 Excel Worksheet Functions 6 March 2nd 06 12:02 AM How to make many random test outcomes in one chart? vegas Excel Discussion (Misc queries) 4 July 11th 05 11:03 AM

All times are GMT +1. The time now is 09:30 PM.