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):
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Away[/TD]
[TD]Home[/TD]
[/TR]
[TR]
[TD]May 1[/TD]
[TD]Team 1[/TD]
[TD]Team 2[/TD]
[/TR]
[TR]
[TD]May 1[/TD]
[TD]Team 3[/TD]
[TD]Team 2[/TD]
[/TR]
[TR]
[TD]May 1[/TD]
[TD]Team 4[/TD]
[TD]Team 3[/TD]
[/TR]
[TR]
[TD]May 8[/TD]
[TD]Team 2[/TD]
[TD]Team 1[/TD]
[/TR]
[TR]
[TD]May 8[/TD]
[TD]Team 2[/TD]
[TD]Team 4[/TD]
[/TR]
[TR]
[TD]May 8[/TD]
[TD]Team 4[/TD]
[TD]Team 3[/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to be able to keep the number of double headers relatively balanced, so I want a table like this:
[TABLE="width: 600"]
<tbody>[TR]
[TD]Team[/TD]
[TD]Double Headers[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]COUNTIF("Team 1" appears twice in column B or C beside the same date in col A)[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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...
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Away[/TD]
[TD]Home[/TD]
[/TR]
[TR]
[TD]May 1[/TD]
[TD]Team 1[/TD]
[TD]Team 2[/TD]
[/TR]
[TR]
[TD]May 1[/TD]
[TD]Team 3[/TD]
[TD]Team 2[/TD]
[/TR]
[TR]
[TD]May 1[/TD]
[TD]Team 4[/TD]
[TD]Team 3[/TD]
[/TR]
[TR]
[TD]May 8[/TD]
[TD]Team 2[/TD]
[TD]Team 1[/TD]
[/TR]
[TR]
[TD]May 8[/TD]
[TD]Team 2[/TD]
[TD]Team 4[/TD]
[/TR]
[TR]
[TD]May 8[/TD]
[TD]Team 4[/TD]
[TD]Team 3[/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to be able to keep the number of double headers relatively balanced, so I want a table like this:
[TABLE="width: 600"]
<tbody>[TR]
[TD]Team[/TD]
[TD]Double Headers[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]COUNTIF("Team 1" appears twice in column B or C beside the same date in col A)[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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...