Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-01-2017, 07:05 AM
mreynolds1775 mreynolds1775 is offline laregest 30 consecutive average of values in a 180 cell range Windows 10 laregest 30 consecutive average of values in a 180 cell range Office 2013
Novice
laregest 30 consecutive average of values in a 180 cell range
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
laregest 30 consecutive average of values in a 180 cell range Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow FUGMAN Excel Programming 7 02-05-2017 08:37 AM
average formal if cell contains number and text Michael Labuschagne Excel 2 12-08-2016 06:35 AM
laregest 30 consecutive average of values in a 180 cell range If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C rick10r Excel 1 07-05-2016 12:07 PM
Filling the consecutive cell by day. aligahk06 Excel 1 09-15-2010 08:17 AM
calculate average depending on drop-down values virencm Word 0 08-06-2010 06:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft