# Random

#### Sheepskin_Coat

##### New Member
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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

#### drc2265

##### Board Regular
Looks like fantasy football? lol, cant answer this though, tough one.

#### Sheepskin_Coat

##### New Member
I cannot get it to work like the example i get either 1 vs 1 or 8 vs 8 all down the list every time i change it

#### Scott Huish

##### MrExcel MVP
What do you have in D2:D5?

#### kmillen

##### Board Regular
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.

#### Sheepskin_Coat

##### New Member
What do you have in D2:D5?

Thats not the problem i do not get random numbers, they are the same in all eight b cells

#### Scott Huish

##### MrExcel MVP
Then what formulas do you have in B1:B8?

Although I may have misunderstood the question. This just generates one set of unique combinations.

#### Sheepskin_Coat

##### New Member
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

#### Scott Huish

##### MrExcel MVP

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?

Replies
0
Views
223
Replies
3
Views
299
Replies
9
Views
447
Replies
6
Views
394
Replies
3
Views
268

1,191,054
Messages
5,984,388
Members
439,883
Latest member
onions44

### 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.

### Which adblocker are you using?

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

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