Rolling 12 month average

  • Thread starter Thread starter mthorn077
  • Start date Start date
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!
 
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...
 
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
 
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

Create a 12 month rolling average 15
Calculating Social Security 3
Calculating total number of days in rolling year 1
DGET lookup failing 6
Excel Excel Dynamic Charting in rows 0
Averaging 3
Rolling average 2
rolling 12 month average 5

Back
Top