View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trip[_3_] Trip[_3_] is offline
external usenet poster
 
Posts: 44
Default 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