Thread: Calculate the most recently entered data in columns?
View Single Post
 
Old 09-18-2017, 10:07 AM
mreynolds1775 mreynolds1775 is offline Windows 10 Office 2013
Novice
  
Join Date: Sep 2017
Posts: 12
mreynolds1775 is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
To avoid volatile functions in C3
=(SUM($E3:$Z3)-SUM($E3:INDEX($E3:$Z3,MATCH(9.99E+307,$E3:$Z3)-3)))/3

and pull down as needed
Replace the 3 with seven for D3
Adapt ranges as needed

Peco,

This works! is there any relevance behind the 9.99E+307 part?
Reply With Quote