I am trying to make a schedule for my ball league and I have it organized like this (there is other info like game time and location as well, but that isn't really relevant to this question):
<tbody>
</tbody>
I want to be able to keep the number of double headers relatively balanced, so I want a table like this:
<tbody>
</tbody>
I've figured out how to do it for game times, but matching the date is throwing me off. I'm not sure if I need to use a lookup or countifs, or some kind of combination any help would be appreciated...
| Date | Away | Home |
| May 1 | Team 1 | Team 2 |
| May 1 | Team 3 | Team 2 |
| May 1 | Team 4 | Team 3 |
| May 8 | Team 2 | Team 1 |
| May 8 | Team 2 | Team 4 |
| May 8 | Team 4 | Team 3 |
| ... |
<tbody>
</tbody>
I want to be able to keep the number of double headers relatively balanced, so I want a table like this:
| Team | Double Headers |
| 1 | COUNTIF("Team 1" appears twice in column B or C beside the same date in col A) |
| 2 | |
| 3 | |
| ... |
<tbody>
</tbody>
I've figured out how to do it for game times, but matching the date is throwing me off. I'm not sure if I need to use a lookup or countifs, or some kind of combination any help would be appreciated...
