Random

Sheepskin_Coat

New Member
Joined
Aug 16, 2007
Messages
24
I have eight teams and i want them to play each other i.e

1 v 2
3 v 4

and so on till all teams have played each other, can i do this randomly
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
There are only 56 games (each of 8 teams playing the other 7). Not wanting to sound simplistic, enter them manually; I did it on my computer in less than 3 minutes.

1. In column A, enter seven ones, seven, twos, etc.
2. In column B, enter enter each of the seven other seven team numbers without duplicating the number in column A
3. In cell C1, enter the formula: =A1 & " vs " & B1 and drag it down 56 rows.
4. Select the 56 values in column C
5. Right click the selection and select Copy
6. Right click cell C1
7. Paste Special | Values
8. Delete columns A and B

Easy.
 
Upvote 0
Then what formulas do you have in B1:B8?

Although I may have misunderstood the question. This just generates one set of unique combinations.
 
Upvote 0
the same as you put on this board..

in A1-A8 i have put =RAND()
in B1-B8 i have put =RANK(A1,$A$1:$A$8)
in D2-D5 i have put =B1 & " vs " & B2 and so on

in cell A1 i get i.e. 1
in cell A2 i get i.e. 2
in cell A3 i get i.e. 1
in cell A4 i get i.e. 1
in cell A5 i get i.e. 1
in cell A6 i get i.e. 1
in cell A7 i get i.e. 1
in cell A8 i get i.e. 1

what to do now
 
Upvote 0
Sorry, I gotta ask this:

In B1, it says =RANK(A1,$A$1:$A$8)

In B2, does it say
=RANK(A2,$A$1:$A$8)

and so on donward to B8?
 
Upvote 0

Forum statistics

Threads
1,213,530
Messages
6,114,163
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top