Thread
:
laregest 30 consecutive average of values in a 180 cell range
View Single Post
10-01-2017, 10:56 PM
xor
Windows 10
Office 2016
Expert
Join Date: Oct 2015
Posts: 1,100
I am not sure, but you can try to take a look at row 14 in the attached file.
Cell B14 shows the average sales for first 30 days, cell C14 shows average sales for 02-jan-17 to 31-jan-17 and so on.
Attached Files
high average sales over large range_2.xlsx
(16.5 KB, 11 views)
xor
View Public Profile
Find all posts by xor