what is the formula for calculating a rolling average
F Frank Kabel May 5, 2004 #2 Hi a little bit more information would be helpful. Probably a combination of AVERAGE and OFFSET would do
Hi a little bit more information would be helpful. Probably a combination of AVERAGE and OFFSET would do
J JE McGimpsey May 5, 2004 #3 Depends on how your data is laid out... One way: Assume data in column A, and want a 10-value rolling average in column B. B10: =AVERAGE(A1:A10) and copy down. XL will adjust the cell references.
Depends on how your data is laid out... One way: Assume data in column A, and want a 10-value rolling average in column B. B10: =AVERAGE(A1:A10) and copy down. XL will adjust the cell references.
