Hi folks,
I'm looking for a formula that extracts the average goals of the previous 6 games for a given team, ie using the date of team A's 7th game I'm looking for the average goals of team A's games 1 to 6 inclusive.
Can't get it to work, I hope someone can help as it would save me hours of huffing and puffing.
TEAM DATE GOALS
Team A 1st Jan 2012 3
Team B 1st Jan 2012 2
Team C 2nd Jan 2012 0
Team A 8th Jan 2012 1
Bookmarks