Dear all,
i have a list of Clubs, as shown below. I would like to avoid having same players from the same clubs sit together.
Is there a way to randomize it?
A table of players usually consists of 4 players. Of course, you can't avoid it fully, but a little randomization would surely help.
Any ideas?
Lena
i have a list of Clubs, as shown below. I would like to avoid having same players from the same clubs sit together.
Is there a way to randomize it?
A table of players usually consists of 4 players. Of course, you can't avoid it fully, but a little randomization would surely help.
Tourney.xlsm | ||||
---|---|---|---|---|
N | O | |||
1 | Player | Club | ||
2 | Player 1 | LA | ||
3 | Player 2 | LA | ||
4 | Player 3 | DE | ||
5 | Player 4 | LA | ||
6 | Player 5 | LA | ||
7 | Player 6 | LA | ||
8 | Player 7 | LA | ||
9 | Player 8 | LA | ||
10 | Player 9 | DE | ||
11 | Player 10 | DE | ||
12 | Player 11 | DE | ||
13 | Player 12 | DE | ||
14 | Player 13 | DE | ||
15 | Player 14 | DE | ||
16 | Player 15 | DE | ||
17 | Player 16 | DE | ||
18 | Player 17 | DE | ||
19 | Player 18 | DE | ||
20 | Player 19 | LV | ||
21 | Player 20 | LV | ||
22 | Player 21 | LV | ||
23 | Player 22 | LV | ||
24 | Player 23 | LV | ||
25 | Player 24 | LV | ||
26 | Player 25 | LV | ||
27 | Player 26 | LV | ||
28 | Player 27 | LV | ||
29 | Player 28 | LV | ||
30 | Player 29 | LV | ||
31 | Player 30 | MN | ||
32 | Player 31 | MN | ||
33 | Player 32 | MN | ||
34 | Player 33 | MN | ||
35 | Player 34 | CANM | ||
PlayerPool |
Any ideas?
Lena