I have an array arrData(800,15). I want to find the standard deviation of the data in arrData(800,10). Is there a way to do this without entering 800 rows in an excel spreadsheet and using STDEV.S there? Thanks.
Printable View
I have an array arrData(800,15). I want to find the standard deviation of the data in arrData(800,10). Is there a way to do this without entering 800 rows in an excel spreadsheet and using STDEV.S there? Thanks.
have you seen this:
VBA: Multidimentional Array Syntax for STDEV Evaluation | MrExcel Message Board
Code:sd = Application.StDev_S(Application.Index(arrData, ,10))