excelbytes
Active Member
- Joined
- Dec 11, 2014
- Messages
- 251
- Office Version
- 365
- Platform
- Windows
I have two groups #1 & #2. I need to create random pairs between the two groups, however I need to make sure that the pairings from Group #1 and Group #2 are not on the same team. Is there a way to do this?
Team Pairing.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Group #1 | Group #2 | |||||
2 | Number | Team | Number | Team | |||
3 | 1 | A | 70 | A | |||
4 | 2 | A | 71 | A | |||
5 | 3 | A | 72 | A | |||
6 | 4 | A | 73 | A | |||
7 | 5 | A | 74 | A | |||
8 | 6 | A | 75 | A | |||
9 | 7 | B | 76 | B | |||
10 | 8 | B | 77 | B | |||
11 | 9 | B | 78 | B | |||
12 | 10 | C | 79 | C | |||
13 | 11 | C | 80 | C | |||
14 | 12 | C | 81 | C | |||
15 | 13 | D | 82 | D | |||
16 | 14 | C | 83 | C | |||
17 | 15 | C | 84 | C | |||
18 | 16 | E | 85 | E | |||
19 | 17 | E | 86 | E | |||
20 | 18 | E | 87 | E | |||
21 | 19 | E | 88 | E | |||
22 | 20 | E | 89 | E | |||
23 | 21 | E | 90 | E | |||
24 | 22 | F | 91 | F | |||
25 | 23 | F | 92 | F | |||
26 | 24 | F | 93 | F | |||
27 | 25 | G | 94 | G | |||
28 | 26 | G | 95 | G | |||
29 | 27 | G | 96 | G | |||
30 | 28 | H | 97 | H | |||
31 | 29 | H | 98 | H | |||
32 | 30 | H | 99 | H | |||
33 | 31 | I | 100 | I | |||
34 | 32 | I | 101 | I | |||
35 | 33 | I | 102 | I | |||
36 | 34 | J | 103 | J | |||
37 | 35 | J | 104 | J | |||
38 | 36 | J | 105 | J | |||
39 | 37 | J | 106 | J | |||
40 | 38 | J | 107 | J | |||
41 | 39 | J | 108 | J | |||
42 | 40 | K | 109 | K | |||
43 | 41 | K | 110 | K | |||
44 | 42 | K | 111 | K | |||
45 | 43 | L | 112 | L | |||
46 | 44 | L | 113 | L | |||
47 | 45 | L | 114 | L | |||
48 | 46 | M | 115 | M | |||
49 | 47 | M | 116 | M | |||
50 | 48 | M | 117 | M | |||
51 | 49 | N | 118 | N | |||
52 | 50 | N | 119 | N | |||
53 | 51 | N | 120 | N | |||
54 | 52 | N | 121 | N | |||
55 | 53 | N | 122 | N | |||
56 | 54 | N | 123 | N | |||
57 | 55 | O | 124 | O | |||
58 | 56 | O | 125 | O | |||
59 | 57 | O | 126 | O | |||
60 | 58 | O | 127 | O | |||
61 | 59 | O | 128 | O | |||
62 | 60 | O | 129 | O | |||
63 | 61 | P | 130 | P | |||
64 | 62 | P | 131 | P | |||
65 | 63 | P | 132 | P | |||
66 | 64 | D | 133 | D | |||
67 | 65 | D | 134 | D | |||
68 | 66 | D | 135 | D | |||
69 | 67 | Q | 136 | Q | |||
70 | 68 | Q | 137 | Q | |||
71 | 69 | Q | 138 | Q | |||
Sheet1 |