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?