Dynamic Formulas for creating an Average for multiple years

[apatel1501]

I have 10 years of revenue and quantity data for a particular product, I need to create a price column for each year.  The tricky part is - sometimes my data will have 2 years or 3 years or any number of years up to 10.  Is there a way to dynamically calculate price for each year that I may have data for without having to create a formula for each year and then disable certain years.

If a macro is a more viable solution - i'm open to that but i am very new to macros so i'm looking for a more non-macro way first that i could then evolve into a macro. But like i said - if macro is the only viable solution, that's okay.

Data attached. 

Thanks!

[binuacs]

@apatel1501 can you provide the expected output based on the input file you provided?

[Christina_H · Accepted solution]

Based on your screenshots, I think you want something like this?

[apatel1501]

this is exactly what i was looking for - thanks! very simple solution.