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?
|