Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.