711excelhelp
New member
- Joined
- Jul 11, 2020
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2013
[FONT="]My problem is as follows: I have the below schedule for a series of games between 4 teams. For these games, TeamX is allowed to scout any games of their next opponent prior to the match-up with TeamX's match-up with said opponent. So for example, AvsB is Game 1, CvsD is Game 2, AvsC is Game 3. A would be able to scout Game2 because Team C is their next opponent at the time of Game 2. How I determine who a next teams opponent is formulaically, then determine which games of that opponent they can scout?[/FONT]
[FONT="]
[/FONT]
[FONT="]I.e., In column for, I would like to formulaically "A" in the empty column for Game # 4 & 6, because Team D is Team A's next opponent at the time Team D plays those games. The fourth column is a helper column on the assumption it is easier to match to a martial match-up given there are are two columns a team could be found in.[/FONT]
[FONT="]
[/FONT]
[FONT="]
[/FONT]
[FONT="]
[/FONT]
[FONT="]I.e., In column for, I would like to formulaically "A" in the empty column for Game # 4 & 6, because Team D is Team A's next opponent at the time Team D plays those games. The fourth column is a helper column on the assumption it is easier to match to a martial match-up given there are are two columns a team could be found in.[/FONT]
[FONT="]
[/FONT]
[FONT="]
[/FONT]
Game # | Away | Home | ||
1 | A | B | A-B | |
2 | C | D | C-D | |
3 | A | C | A-C | |
4 | B | D | B-D | |
5 | B | C | B-C | |
6 | C | D | C-D | |
7 | A | B | A-B | |
8 | A | D | A-D | |
9 | B | C | B-C | |
10 | A | D | A-D | |