dougf1r
asked on
Average columns of data based on values in another column
original_question.xlsx
A solution to a similar question to this one has previously been provided:
https://www.experts-exchange.com/questions/29094062/Lookup-data-based-on-values-in-another-column.html
This time, what is needed is the average value of the 30 years of "n" data leading up to and including the year listed in the "year" field (Column B). This result should be included in the "n_30yr_avg" field (Column C).
The first 52 values for "n_30yr_avg" have been solved manually in the attached worksheet.
Is there a solution that would provide this calculation for all records?
A solution to a similar question to this one has previously been provided:
https://www.experts-exchange.com/questions/29094062/Lookup-data-based-on-values-in-another-column.html
This time, what is needed is the average value of the 30 years of "n" data leading up to and including the year listed in the "year" field (Column B). This result should be included in the "n_30yr_avg" field (Column C).
The first 52 values for "n_30yr_avg" have been solved manually in the attached worksheet.
Is there a solution that would provide this calculation for all records?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works great, many thanks!
ASKER