Highest 50 Day Rolling Average

C

cincyman

Joined
Sep 24, 2008
Messages
4
Reaction score
0
Ok I am going to be collecting data points in column A for an unknown number of days but I need one cell in column B to calculate the highest 50 day rolling average over the data points in column A. I don't want it to constantly give me the last 50 day rolling average but the highest 50 day rolling average over all the data points. Please Help. Thank you in advance.
 
Well I figured out a way around it by having a rolling average column and then having a cell read the max value in the column but I was hoping someone might know a way to do this all in one column. Is it possible?
 
Back
Top