There's a file I have that shows the full season schedule with score results from a pro sports league last year. I have five columns in the file:
Column A: contains list of dates (868 dates to be exact, this is all the games that were played that season)
Column B: the name of the team
Column C: the name of the opponent that the team from Column B played on that night.
Column D: the number of goals that the team from Column B scored
Column E: the number of goals that the team from Column C scored
In sports, there are obviously days off in between games. Sometimes it's one day off, two days, three, four, and sometimes there aren't any. What I'm wanting to do is run a query that identifies how many times the team from Column B had:
1.) Games played with no days of rest in between games
2.) Games played with one day of rest in between games
3.) Games played with two days of rest in between games
4.) Games played with three days of rest in between games
5.) Games played with four or more days of rest in between games
Ideally it would be great if it identified how many times instances 1-5 appeared without considering who the team is, but I get that might be difficult if you don't actually put the team name from Column B in the query.
Column A: contains list of dates (868 dates to be exact, this is all the games that were played that season)
Column B: the name of the team
Column C: the name of the opponent that the team from Column B played on that night.
Column D: the number of goals that the team from Column B scored
Column E: the number of goals that the team from Column C scored
In sports, there are obviously days off in between games. Sometimes it's one day off, two days, three, four, and sometimes there aren't any. What I'm wanting to do is run a query that identifies how many times the team from Column B had:
1.) Games played with no days of rest in between games
2.) Games played with one day of rest in between games
3.) Games played with two days of rest in between games
4.) Games played with three days of rest in between games
5.) Games played with four or more days of rest in between games
Ideally it would be great if it identified how many times instances 1-5 appeared without considering who the team is, but I get that might be difficult if you don't actually put the team name from Column B in the query.