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.
Quote Reply
Report
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