Frequency Count

Status
Not open for further replies.

MHau5

New Member
Joined
Oct 23, 2021
Messages
26
Office Version
  1. 2019
Platform
  1. Windows
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
ABCDEF
1DateVisitorGHomeG2Column1
21/13/2021St. Louis Blues4Colorado Avalanche1
31/13/2021Vancouver Canucks5Edmonton Oilers3
41/13/2021Pittsburgh Penguins3Philadelphia Flyers6
51/13/2021Chicago Blackhawks1Tampa Bay Lightning5
61/13/2021Montreal Canadiens4Toronto Maple Leafs5OT
71/14/2021San Jose Sharks4Arizona Coyotes3SO
81/14/2021Washington Capitals6Buffalo Sabres4
91/14/2021Carolina Hurricanes3Detroit Red Wings0
101/14/2021Vancouver Canucks2Edmonton Oilers5
111/14/2021Minnesota Wild4Los Angeles Kings3OT
121/14/2021Boston Bruins3New Jersey Devils2SO
131/14/2021Columbus Blue Jackets1Nashville Predators3
141/14/2021New York Islanders4New York Rangers0
151/14/2021Anaheim Ducks2Vegas Golden Knights5
161/14/2021Calgary Flames3Winnipeg Jets4OT
171/15/2021Washington Capitals2Buffalo Sabres1
181/15/2021St. Louis Blues0Colorado Avalanche8
191/15/2021Toronto Maple Leafs3Ottawa Senators5
201/15/2021Pittsburgh Penguins2Philadelphia Flyers5
211/15/2021Chicago Blackhawks2Tampa Bay Lightning5
221/16/2021San Jose Sharks3Arizona Coyotes5
231/16/2021Vancouver Canucks0Calgary Flames3
241/16/2021Carolina Hurricanes2Detroit Red Wings4
251/16/2021Montreal Canadiens5Edmonton Oilers1
261/16/2021Minnesota Wild4Los Angeles Kings3OT
271/16/2021Boston Bruins1New Jersey Devils2OT
281/16/2021Columbus Blue Jackets2Nashville Predators5
291/16/2021New York Islanders0New York Rangers5
301/16/2021Toronto Maple Leafs3Ottawa Senators2
311/16/2021Anaheim Ducks1Vegas Golden Knights2OT
321/17/2021Chicago Blackhawks2Florida Panthers5
331/17/2021Washington Capitals3Pittsburgh Penguins4SO
341/18/2021Minnesota Wild0Anaheim Ducks1
351/18/2021Vancouver Canucks2Calgary Flames5
361/18/2021Columbus Blue Jackets3Detroit Red Wings2
371/18/2021Montreal Canadiens3Edmonton Oilers1
381/18/2021Carolina Hurricanes4Nashville Predators2
391/18/2021Boston Bruins0New York Islanders1
401/18/2021Buffalo Sabres6Philadelphia Flyers1
411/18/2021San Jose Sharks4St. Louis Blues5
421/18/2021Winnipeg Jets1Toronto Maple Leafs3
431/18/2021Arizona Coyotes2Vegas Golden Knights4
441/19/2021Columbus Blue Jackets2Detroit Red Wings3OT
451/19/2021Chicago Blackhawks4Florida Panthers5OT
461/19/2021Colorado Avalanche3Los Angeles Kings2
471/19/2021New Jersey Devils4New York Rangers3
481/19/2021Winnipeg Jets4Ottawa Senators3OT
491/19/2021Buffalo Sabres0Philadelphia Flyers3
501/19/2021Washington Capitals4Pittsburgh Penguins5OT
511/20/2021Minnesota Wild3Anaheim Ducks2
521/20/2021San Jose Sharks2St. Louis Blues1SO
531/20/2021Edmonton Oilers3Toronto Maple Leafs1
541/20/2021Montreal Canadiens5Vancouver Canucks6SO
551/20/2021Arizona Coyotes2Vegas Golden Knights5
561/21/2021Philadelphia Flyers4Boston Bruins5SO
571/21/2021Tampa Bay Lightning3Columbus Blue Jackets2OT
581/21/2021Colorado Avalanche2Los Angeles Kings4
591/21/2021New Jersey Devils1New York Islanders4
601/21/2021Winnipeg Jets4Ottawa Senators1
611/21/2021Montreal Canadiens7Vancouver Canucks3
621/22/2021Colorado Avalanche3Anaheim Ducks2OT
631/22/2021Vegas Golden Knights2Arizona Coyotes5
641/22/2021Detroit Red Wings1Chicago Blackhawks4
651/22/2021Nashville Predators0Dallas Stars7
661/22/2021San Jose Sharks1Minnesota Wild4
671/22/2021New York Rangers3Pittsburgh Penguins4SO
681/22/2021Edmonton Oilers2Toronto Maple Leafs4
691/22/2021Buffalo Sabres3Washington Capitals4SO
701/23/2021Philadelphia Flyers1Boston Bruins6
711/23/2021Tampa Bay Lightning2Columbus Blue Jackets5
721/23/2021Los Angeles Kings2St. Louis Blues4
731/23/2021Montreal Canadiens5Vancouver Canucks2
741/23/2021Ottawa Senators3Winnipeg Jets6
751/24/2021Colorado Avalanche1Anaheim Ducks3
761/24/2021Vegas Golden Knights1Arizona Coyotes0
771/24/2021Toronto Maple Leafs3Calgary Flames2
781/24/2021Detroit Red Wings2Chicago Blackhawks6
791/24/2021Nashville Predators2Dallas Stars3
801/24/2021San Jose Sharks5Minnesota Wild3
811/24/2021New York Islanders0New Jersey Devils2
821/24/2021New York Rangers2Pittsburgh Penguins3
831/24/2021Los Angeles Kings6St. Louis Blues3
841/24/2021Edmonton Oilers4Winnipeg Jets3
851/24/2021Buffalo Sabres4Washington Capitals3SO
861/25/2021Ottawa Senators1Vancouver Canucks7
871/26/2021Anaheim Ducks1Arizona Coyotes0
881/26/2021Pittsburgh Penguins2Boston Bruins3OT
891/26/2021New York Rangers2Buffalo Sabres3
901/26/2021Florida Panthers4Columbus Blue Jackets3SO
911/26/2021Toronto Maple Leafs4Calgary Flames3
921/26/2021San Jose Sharks3Colorado Avalanche7
931/26/2021Detroit Red Wings1Dallas Stars2OT
941/26/2021Los Angeles Kings2Minnesota Wild1
951/26/2021Philadelphia Flyers5New Jersey Devils3
961/26/2021Chicago Blackhawks2Nashville Predators3OT
971/26/2021St. Louis Blues5Vegas Golden Knights4SO
981/26/2021Edmonton Oilers4Winnipeg Jets6
991/26/2021New York Islanders2Washington Capitals3
1001/27/2021Chicago Blackhawks1Nashville Predators2SO
1011/27/2021Ottawa Senators1Vancouver Canucks5
1021/28/2021Anaheim Ducks2Arizona Coyotes3
1031/28/2021Pittsburgh Penguins1Boston Bruins4
1041/28/2021New York Rangers3Buffalo Sabres2OT
1051/28/2021Tampa Bay Lightning0Carolina Hurricanes1OT
1061/28/2021Florida Panthers2Columbus Blue Jackets3SO
1071/28/2021San Jose Sharks0Colorado Avalanche3
1081/28/2021Detroit Red Wings3Dallas Stars7
1091/28/2021Toronto Maple Leafs4Edmonton Oilers3
1101/28/2021Los Angeles Kings3Minnesota Wild5
1111/28/2021Calgary Flames2Montreal Canadiens4
1121/28/2021Philadelphia Flyers3New Jersey Devils1
1131/28/2021Ottawa Senators1Vancouver Canucks4
1141/28/2021New York Islanders3Washington Capitals6
1151/29/2021Columbus Blue Jackets2Chicago Blackhawks1
1161/30/2021St. Louis Blues6Anaheim Ducks1
1171/30/2021New Jersey Devils3Buffalo Sabres4SO
1181/30/2021Dallas Stars1Carolina Hurricanes4
1191/30/2021Florida Panthers3Detroit Red Wings2OT
1201/30/2021Toronto Maple Leafs3Edmonton Oilers4OT
1211/30/2021Colorado Avalanche5Minnesota Wild1
1221/30/2021Calgary Flames2Montreal Canadiens0
1231/30/2021Pittsburgh Penguins5New York Rangers4OT
1241/30/2021New York Islanders2Philadelphia Flyers3OT
1251/30/2021Nashville Predators3Tampa Bay Lightning4
1261/30/2021Vancouver Canucks4Winnipeg Jets1
1271/30/2021Boston Bruins3Washington Capitals4OT
1281/31/2021St. Louis Blues4Anaheim Ducks1
1291/31/2021New Jersey Devils5Buffalo Sabres3
1301/31/2021Dallas Stars3Carolina Hurricanes4SO
1311/31/2021Columbus Blue Jackets1Chicago Blackhawks3
1321/31/2021Florida Panthers3Detroit Red Wings2
1331/31/2021Ottawa Senators5Edmonton Oilers8
1341/31/2021Colorado Avalanche3Minnesota Wild4OT
1351/31/2021New York Islanders3Philadelphia Flyers4OT
Schedule


Quote Reply
Report
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,223,162
Messages
6,170,432
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top