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...