ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Application.Stdev(multiDimensionArray) ? (https://www.excelbanter.com/excel-programming/389202-application-stdev-multidimensionarray.html)

Trip[_3_]

Application.Stdev(multiDimensionArray) ?
 
Hello all,

I would like to be able to use the Application.Stdev(myArray) function
but "myArray" actually has two dimendions (1,10000). Is it possible
to use the function to calculate the stdev of just the second
dimension? Or, are there any slick work-arounds to segregate the
second disension for a particular row (0 or 1) without looping through
the array?

Thanks a lot!!

Trip



All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com