Moving Average for given N Number

Hello Friends

Please find the attached excel 2010 version file <Moving Average for given N Number.xlsx>

I want to calculate the moving average for the given (Last) `N' numbers. The green cells are inputs and based on the value in green cells the yellow cells has to be populated by formula.

I can use the formula in Cell C5 <=AVERAGE(A3:A5)> and in Cell E7 <=AVERAGE(A3:A7)> (can drag upto C18 & E18), but the problem is if i want to change the moving average from 3 & 5 to some other number means again i have to apply formula and repopuilate the values.

thanks in advance


thilag

HI Try with this =AVERAGE(INDIRECT(ADDRESS(C1,1)&":"&ADDRESS(E1,1))) also.

Hello XOR LX & Hello rajansettu

Thank you for your quick reply.

thanks again

thilag