Calculating moving average
 

I would like to calculate the 2-period moving average of a dataset in
A1:A20. I understand that this can be done by AVERAGE(A1:A2) and the
other moving averages will appear in the selected column when
"dragging" the formula to the other cells of the column. My problem is
that i would like to see the results diagonally instead of vertically
(B3,C4,D5,E6,F7 etc. instead of B3,B4,B5,B6,B7 etc.) Can somebody help
me?

Calculating moving average
 

Try

=AVERAGE(INDEX($A$1:$A$20,ROW()-1):INDEX($A$1:$A$20,ROW()))

In B3

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
oups.com...
I would like to calculate the 2-period moving average of a dataset in
A1:A20. I understand that this can be done by AVERAGE(A1:A2) and the
other moving averages will appear in the selected column when
"dragging" the formula to the other cells of the column. My problem is
that i would like to see the results diagonally instead of vertically
(B3,C4,D5,E6,F7 etc. instead of B3,B4,B5,B6,B7 etc.) Can somebody help
me?