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.
 
C

cincyman

Joined
Sep 24, 2008
Messages
4
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a 12 month rolling average 15
Annualized rolling (moving) average 2
Rolling Average 5
Running total over a find number of days 12
Remove punctuation mark, Split cells & average accross column 4
How to do a rolling average on a query that asks for input 8
30 Day Moving Average Ignoring Blank Cells 2
Rolling totals 1

Top