Dynamic Range and arrays

[PR]

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

 

[DOR]

I recently solved this problem for someone else. If you would send me
your spreadsheet, I can do it for you.

Declan O'R