dtaylor646
New Member
- Joined
- Jun 12, 2018
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hello everyone,
Though some other posts have had similar solutions, I want to pair a list of unique identifiers to others with each pairing unique for each month. April has #1 with #3 and necessarily #3 with #1 The first three pairings were manual and would like a formula to generate the other pairings for other months, where the pairings do not repeat from the previous months' pairs. Thank you for any and all help!
<tbody>
</tbody>
Though some other posts have had similar solutions, I want to pair a list of unique identifiers to others with each pairing unique for each month. April has #1 with #3 and necessarily #3 with #1 The first three pairings were manual and would like a formula to generate the other pairings for other months, where the pairings do not repeat from the previous months' pairs. Thank you for any and all help!
Identifier | April | May | June | July |
1 | 3 | 2 | 4 | [formula here] |
2 | 4 | 1 | 3 | |
3 | 1 | 4 | 2 | |
4 | 2 | 3 | 1 | |
5 | 7 | 6 | 8 | |
6 | 8 | 5 | 14 | |
7 | 5 | 8 | 20 | |
8 | 6 | 7 | 5 | |
9 | 11 | 10 | 12 | |
10 | 12 | 9 | 11 | |
11 | 9 | 12 | 10 | |
12 | 10 | 11 | 9 | |
13 | 19 | 14 | 15 | |
14 | 20 | 13 | 6 | |
15 | 17 | 16 | 13 | |
16 | 18 | 15 | 17 | |
17 | 15 | 18 | 16 | |
18 | 16 | 17 | 19 | |
19 | 13 | 20 | 18 | |
20 | 14 | 19 | 7 |
<tbody>
</tbody>