Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dynamic Range and arrays
Hi,
I have a formula to calculate team records for the season so far based on the game results. But I need help on a formula to calculate teams record (Wins-Loss-Ties) in their last 5 games in a league. To calculate Wins for the whole season, my range includes all the rows in my table. For the last 5 games, I would need a formula to find the range of a team's last 5 games; something like rows 125:150 instead of rows 2:1000. My table has the games for the whole season, so some games don't have scores yet. So I have 1000 rows for games, but only 150 have game results. My table is setup as follows A B C D E Date Visitor Score Home Score Thanks, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range and arrays | Excel Discussion (Misc queries) | |||
Dynamic arrays | New Users to Excel | |||
Arrays Take too long. VERY HARD QUESTION. my head hurts : / | Excel Worksheet Functions | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
syntax to refer to a range as an array? | Excel Worksheet Functions |