Formula for defining range based on criteria

J

JSweet

New Member
Joined
Feb 1, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
I am creating a football sports model in Excel. I have a list of the "home" teams in column A and the "away" teams in column B (each row depicts one match between 2 teams). Because this is an entire season, there are obviously several duplicates of the teams in the columns (as a team plays more than once in a season). This also means that all teams will appear more than once in both columns. I am looking for a formula to define the range of a team's last 5 games in the season, so that when I add more matches, it adjusts. Thank you in advance to anyone that can help!!
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Sort by date Sort by votes
More specifically, the question I'm trying to answer with this formula is "what is the range of *team*'s last 5 matches.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
NFL Game Prediction Question
Replies
8
Views
285
stevek99022
S
S
  • Solved
Summary Report
2
Replies
10
Views
129
Steve 1962
S
D
  • Question
Use formula in sports analysis to check accuracy of predictions which involves if one negative number is more negative than another negative number
Replies
4
Views
458
Micron
M
K
  • Question
Calculating player win-loss records
Replies
1
Views
545
KWD
K
M
  • Solved
VBA Multiple Worksheet Change Events
Replies
3
Views
623
Joe4
Joe4

Forum statistics

Threads
1,214,963
Messages
6,122,484
Members
449,088
Latest member
Melvetica

Share this page

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