Excel Forum

YTLE#105: Excel OFFSET for Dynamic Range in Function

In Excel, use the OFFSET function to deliver a variable range of values to a function. Also see the Match function used in an array formula to find the first positive value.

Use the OFFSET, MATCH and STDEV functions to calculate standard deviation for sample data where the data range varies for each sample in accordance with finding the first positive value in the data set.

Got a Question? Ask it Here in the Forum.