View Single Post
 
Old 05-02-2016, 07:31 AM
gspikesr gspikesr is offline Windows 7 64bit Office 2016
Novice
 
Join Date: May 2016
Posts: 2
gspikesr is on a distinguished road
Default Formula Assistance for restricting the number of for analysis

We have a long rows of data among many names. We want to retain the historical input, but for analysis want to limit the data use in the formula to only the last ten inputs. Some rows have only one input and others as many as 100. For analysis only the last (most current) 1 to 10 data points needed. What formula can be used?
Reply With Quote