How to STDEV on different ranges using Excel formulas?

Consider an Excel file in which we have different group of numbers and we want to calculate STDEV for each rang using a formula. The process is as follow,

Group of numbers in an Excel sheet

 

=IF(A1="",STDEVA(INDIRECT(CELL("address",A2)&":A"&SMALL(IF(A2:A200="",ROW(A2:A200),""),1)-1)),"")

Note: This is an array formula and should be inserted with Ctrl+Shift+Enter
STDEV (Sample Excel File)

Published by

bSuperior System Ltd Experts

We are experts in customizing Excel files and VBA programming. We create Excel files for specific needs. We develop VBA programs to automate tasks and execute processes automatically . We are based in Vancouver BC, Canada.

Leave a Reply

Your email address will not be published. Required fields are marked *