Thread: laregest 30 consecutive average of values in a 180 cell range
View Single Post
 
Old 10-19-2017, 04:03 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
Non-array formula:

=MAX(INDEX(SUBTOTAL(1,(OFFSET($B$2,0,COLUMN($B$2:$ AE$2)-2,1,30))),))
Reply With Quote