View Single Post
 
Old 10-01-2017, 07:05 AM
mreynolds1775 mreynolds1775 is offline Windows 10 Office 2013
Novice
 
Join Date: Sep 2017
Posts: 12
mreynolds1775 is on a distinguished road
Default 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
Reply With Quote