Frequency Count

[MHau5]

There's a file below where 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
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.

New NHL Model.xlsx
	A	B	C	D	E	F
1	Date	Visitor	G	Home	G2	Column1
2	1/13/2021	St. Louis Blues	4	Colorado Avalanche	1
3	1/13/2021	Vancouver Canucks	5	Edmonton Oilers	3
4	1/13/2021	Pittsburgh Penguins	3	Philadelphia Flyers	6
5	1/13/2021	Chicago Blackhawks	1	Tampa Bay Lightning	5
6	1/13/2021	Montreal Canadiens	4	Toronto Maple Leafs	5	OT
7	1/14/2021	San Jose Sharks	4	Arizona Coyotes	3	SO
8	1/14/2021	Washington Capitals	6	Buffalo Sabres	4
9	1/14/2021	Carolina Hurricanes	3	Detroit Red Wings	0
10	1/14/2021	Vancouver Canucks	2	Edmonton Oilers	5
11	1/14/2021	Minnesota Wild	4	Los Angeles Kings	3	OT
12	1/14/2021	Boston Bruins	3	New Jersey Devils	2	SO
13	1/14/2021	Columbus Blue Jackets	1	Nashville Predators	3
14	1/14/2021	New York Islanders	4	New York Rangers	0
15	1/14/2021	Anaheim Ducks	2	Vegas Golden Knights	5
16	1/14/2021	Calgary Flames	3	Winnipeg Jets	4	OT
17	1/15/2021	Washington Capitals	2	Buffalo Sabres	1
18	1/15/2021	St. Louis Blues	0	Colorado Avalanche	8
19	1/15/2021	Toronto Maple Leafs	3	Ottawa Senators	5
20	1/15/2021	Pittsburgh Penguins	2	Philadelphia Flyers	5
21	1/15/2021	Chicago Blackhawks	2	Tampa Bay Lightning	5
22	1/16/2021	San Jose Sharks	3	Arizona Coyotes	5
23	1/16/2021	Vancouver Canucks	0	Calgary Flames	3
24	1/16/2021	Carolina Hurricanes	2	Detroit Red Wings	4
25	1/16/2021	Montreal Canadiens	5	Edmonton Oilers	1
26	1/16/2021	Minnesota Wild	4	Los Angeles Kings	3	OT
27	1/16/2021	Boston Bruins	1	New Jersey Devils	2	OT
28	1/16/2021	Columbus Blue Jackets	2	Nashville Predators	5
29	1/16/2021	New York Islanders	0	New York Rangers	5
30	1/16/2021	Toronto Maple Leafs	3	Ottawa Senators	2
31	1/16/2021	Anaheim Ducks	1	Vegas Golden Knights	2	OT
32	1/17/2021	Chicago Blackhawks	2	Florida Panthers	5
33	1/17/2021	Washington Capitals	3	Pittsburgh Penguins	4	SO
34	1/18/2021	Minnesota Wild	0	Anaheim Ducks	1
35	1/18/2021	Vancouver Canucks	2	Calgary Flames	5
36	1/18/2021	Columbus Blue Jackets	3	Detroit Red Wings	2
37	1/18/2021	Montreal Canadiens	3	Edmonton Oilers	1
38	1/18/2021	Carolina Hurricanes	4	Nashville Predators	2
39	1/18/2021	Boston Bruins	0	New York Islanders	1
40	1/18/2021	Buffalo Sabres	6	Philadelphia Flyers	1
41	1/18/2021	San Jose Sharks	4	St. Louis Blues	5
42	1/18/2021	Winnipeg Jets	1	Toronto Maple Leafs	3
43	1/18/2021	Arizona Coyotes	2	Vegas Golden Knights	4
44	1/19/2021	Columbus Blue Jackets	2	Detroit Red Wings	3	OT
45	1/19/2021	Chicago Blackhawks	4	Florida Panthers	5	OT
46	1/19/2021	Colorado Avalanche	3	Los Angeles Kings	2
47	1/19/2021	New Jersey Devils	4	New York Rangers	3
48	1/19/2021	Winnipeg Jets	4	Ottawa Senators	3	OT
49	1/19/2021	Buffalo Sabres	0	Philadelphia Flyers	3
50	1/19/2021	Washington Capitals	4	Pittsburgh Penguins	5	OT
51	1/20/2021	Minnesota Wild	3	Anaheim Ducks	2
52	1/20/2021	San Jose Sharks	2	St. Louis Blues	1	SO
53	1/20/2021	Edmonton Oilers	3	Toronto Maple Leafs	1
54	1/20/2021	Montreal Canadiens	5	Vancouver Canucks	6	SO
55	1/20/2021	Arizona Coyotes	2	Vegas Golden Knights	5
56	1/21/2021	Philadelphia Flyers	4	Boston Bruins	5	SO
57	1/21/2021	Tampa Bay Lightning	3	Columbus Blue Jackets	2	OT
58	1/21/2021	Colorado Avalanche	2	Los Angeles Kings	4
59	1/21/2021	New Jersey Devils	1	New York Islanders	4
60	1/21/2021	Winnipeg Jets	4	Ottawa Senators	1
61	1/21/2021	Montreal Canadiens	7	Vancouver Canucks	3
62	1/22/2021	Colorado Avalanche	3	Anaheim Ducks	2	OT
63	1/22/2021	Vegas Golden Knights	2	Arizona Coyotes	5
64	1/22/2021	Detroit Red Wings	1	Chicago Blackhawks	4
65	1/22/2021	Nashville Predators	0	Dallas Stars	7
66	1/22/2021	San Jose Sharks	1	Minnesota Wild	4
67	1/22/2021	New York Rangers	3	Pittsburgh Penguins	4	SO
68	1/22/2021	Edmonton Oilers	2	Toronto Maple Leafs	4
69	1/22/2021	Buffalo Sabres	3	Washington Capitals	4	SO
70	1/23/2021	Philadelphia Flyers	1	Boston Bruins	6
71	1/23/2021	Tampa Bay Lightning	2	Columbus Blue Jackets	5
72	1/23/2021	Los Angeles Kings	2	St. Louis Blues	4
73	1/23/2021	Montreal Canadiens	5	Vancouver Canucks	2
74	1/23/2021	Ottawa Senators	3	Winnipeg Jets	6
75	1/24/2021	Colorado Avalanche	1	Anaheim Ducks	3
76	1/24/2021	Vegas Golden Knights	1	Arizona Coyotes	0
77	1/24/2021	Toronto Maple Leafs	3	Calgary Flames	2
78	1/24/2021	Detroit Red Wings	2	Chicago Blackhawks	6
79	1/24/2021	Nashville Predators	2	Dallas Stars	3
80	1/24/2021	San Jose Sharks	5	Minnesota Wild	3
81	1/24/2021	New York Islanders	0	New Jersey Devils	2
82	1/24/2021	New York Rangers	2	Pittsburgh Penguins	3
83	1/24/2021	Los Angeles Kings	6	St. Louis Blues	3
84	1/24/2021	Edmonton Oilers	4	Winnipeg Jets	3
85	1/24/2021	Buffalo Sabres	4	Washington Capitals	3	SO
86	1/25/2021	Ottawa Senators	1	Vancouver Canucks	7
87	1/26/2021	Anaheim Ducks	1	Arizona Coyotes	0
88	1/26/2021	Pittsburgh Penguins	2	Boston Bruins	3	OT
89	1/26/2021	New York Rangers	2	Buffalo Sabres	3
90	1/26/2021	Florida Panthers	4	Columbus Blue Jackets	3	SO
91	1/26/2021	Toronto Maple Leafs	4	Calgary Flames	3
92	1/26/2021	San Jose Sharks	3	Colorado Avalanche	7
93	1/26/2021	Detroit Red Wings	1	Dallas Stars	2	OT
94	1/26/2021	Los Angeles Kings	2	Minnesota Wild	1
95	1/26/2021	Philadelphia Flyers	5	New Jersey Devils	3
96	1/26/2021	Chicago Blackhawks	2	Nashville Predators	3	OT
97	1/26/2021	St. Louis Blues	5	Vegas Golden Knights	4	SO
98	1/26/2021	Edmonton Oilers	4	Winnipeg Jets	6
99	1/26/2021	New York Islanders	2	Washington Capitals	3
100	1/27/2021	Chicago Blackhawks	1	Nashville Predators	2	SO
101	1/27/2021	Ottawa Senators	1	Vancouver Canucks	5
102	1/28/2021	Anaheim Ducks	2	Arizona Coyotes	3
103	1/28/2021	Pittsburgh Penguins	1	Boston Bruins	4
104	1/28/2021	New York Rangers	3	Buffalo Sabres	2	OT
105	1/28/2021	Tampa Bay Lightning	0	Carolina Hurricanes	1	OT
106	1/28/2021	Florida Panthers	2	Columbus Blue Jackets	3	SO
107	1/28/2021	San Jose Sharks	0	Colorado Avalanche	3
108	1/28/2021	Detroit Red Wings	3	Dallas Stars	7
109	1/28/2021	Toronto Maple Leafs	4	Edmonton Oilers	3
110	1/28/2021	Los Angeles Kings	3	Minnesota Wild	5
111	1/28/2021	Calgary Flames	2	Montreal Canadiens	4
112	1/28/2021	Philadelphia Flyers	3	New Jersey Devils	1
113	1/28/2021	Ottawa Senators	1	Vancouver Canucks	4
114	1/28/2021	New York Islanders	3	Washington Capitals	6
115	1/29/2021	Columbus Blue Jackets	2	Chicago Blackhawks	1
116	1/30/2021	St. Louis Blues	6	Anaheim Ducks	1
117	1/30/2021	New Jersey Devils	3	Buffalo Sabres	4	SO
118	1/30/2021	Dallas Stars	1	Carolina Hurricanes	4
119	1/30/2021	Florida Panthers	3	Detroit Red Wings	2	OT
120	1/30/2021	Toronto Maple Leafs	3	Edmonton Oilers	4	OT
121	1/30/2021	Colorado Avalanche	5	Minnesota Wild	1
122	1/30/2021	Calgary Flames	2	Montreal Canadiens	0
123	1/30/2021	Pittsburgh Penguins	5	New York Rangers	4	OT
124	1/30/2021	New York Islanders	2	Philadelphia Flyers	3	OT
125	1/30/2021	Nashville Predators	3	Tampa Bay Lightning	4
126	1/30/2021	Vancouver Canucks	4	Winnipeg Jets	1
127	1/30/2021	Boston Bruins	3	Washington Capitals	4	OT
128	1/31/2021	St. Louis Blues	4	Anaheim Ducks	1
129	1/31/2021	New Jersey Devils	5	Buffalo Sabres	3
130	1/31/2021	Dallas Stars	3	Carolina Hurricanes	4	SO
131	1/31/2021	Columbus Blue Jackets	1	Chicago Blackhawks	3
132	1/31/2021	Florida Panthers	3	Detroit Red Wings	2
133	1/31/2021	Ottawa Senators	5	Edmonton Oilers	8
134	1/31/2021	Colorado Avalanche	3	Minnesota Wild	4	OT
135	1/31/2021	New York Islanders	3	Philadelphia Flyers	4	OT
Schedule

Quote Reply
Report

 

[Fluff]

Duplicate to: Column Counting

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.