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!

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" wrote:

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!

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" wrote:

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" wrote:

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!

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

If this post helps click Yes
---------------
Jacob Skaria


"mthorn077" wrote:

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" wrote:

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" wrote:

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!

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