Rolling 12 month average

[mthorn077]

I'm trying to do a rolling 12 month average of employee compensation.

Rows have employee name, columns have the month and year.

Any ideas???

Thanks for the help!

 

[Jacob Skaria]

Use MATCH() to find the column number of a specifc month/year. and use that
as a parameter in OFFSET() function and average that range..Hope you are
familiar with these formulas....if not post sample data and someone here
should be able to help...

 

[mthorn077]

No, not really familiar with Match and OFFSET function.

Here is a sample of how I have my data set up:
a b c d e
f g h
Emp. Number Employee Name Oct-08 Nov-08 Dec-08 Jan-09 Feb-09 Mar-09
1 J. Doe $2 $4 $7
$5 $8 $2

 

[Jacob Skaria]

Could you please post a sample with the total you are expecting when your
input changes......

If this post helps click Yes

 

[Herbert Seidenberg]

Excel 2007 PivotTable
Running 12 month average.
Advanced user level.
http://www.mediafire.com/file/zw2jmjnyqnt/10_13_09.xlsx