Rolling 12 month average

M

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!
 
J

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...
 
M

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
 
J

Jacob Skaria

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating total number of days in rolling year 1
Create a 12 month rolling average 15
Rolling average 2
DGET lookup failing 6
rolling 12 month date filter for pivot table? 2
rolling 12 month average 5
Anyone know how to set up an employee turnover worksheet? 1
Rolling totals 1

Top