laregest 30 consecutive average of values in a 180 cell range
Good morning all,
I am looking to find the highest 30 day average of sales within a 180 range. I already track total sales by month, but as an example, this doesn't work as an accurate depiction. Example: first half of Aug sales were low, second half were high; first half of September sales were high, and the second were low. The period from mid august to mid September was the highest sales period.
any clue how to find this info? thanks in advance.
-Mike
|