I want to create a champions League style group draw if possible through spreadsheet
As i'm a beginner to excel I don't have a clue how to do this and I am willing to learn if possible
I have 16 teams in columns A1 to A16
I have a seeded section ranging from 1 to 4 with the aim of creating 4 group tables, as shown below
<tbody>
</tbody>
I want each team not to able to draw a team with the same seeded number
for example, Liverpool, Chelsea, Villa and Southampton can all be in the same group, but Manchester and Liverpool can't
Would really appreciate any input for this one.
Thank you in advance
As i'm a beginner to excel I don't have a clue how to do this and I am willing to learn if possible
I have 16 teams in columns A1 to A16
I have a seeded section ranging from 1 to 4 with the aim of creating 4 group tables, as shown below
Manchester | 1 |
Liverpool | 1 |
Arsenal | 1 |
Chelsea | 2 |
Tottenham | 2 |
Leicester | 3 |
Villa | 3 |
Sunderland | 3 |
Newcastle | 4 |
Southampton | 4 |
<tbody>
</tbody>
I want each team not to able to draw a team with the same seeded number
for example, Liverpool, Chelsea, Villa and Southampton can all be in the same group, but Manchester and Liverpool can't
Would really appreciate any input for this one.
Thank you in advance