A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

how to make a random rotation of 6 teams



 
 
Thread Tools Display Modes
  #1  
Old November 30th 09, 10:10 AM posted to microsoft.public.excel.misc
Rick Smith
external usenet poster
 
Posts: 2
Default 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
Ads
  #2  
Old November 30th 09, 11:21 AM posted to microsoft.public.excel.misc
Gary''s Student
external usenet poster
 
Posts: 11,059
Default 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

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

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 02:30 AM
How can I make the rows go into a random order? chicken99 Excel Worksheet Functions 6 March 2nd 06 01: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 02:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.