LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 395
Default Syntax question: using worksheet functions on a subset of a 3-D ar


I have a 3D array that is (1 to 2, 1 to 24, 1 to 12)
first parameter is raw number vs. %
second parameter is hour of the day
third parameter is 5-min increment (within each hour)

I'm taking LAN reports and scraping them to do some bandwidth analysis (I
don't have control over the source data). I've got the data populated into my
array, representing one data point every 5 minutes.

Now I want to run some basic statistics against my array, for example:
For hour 14, what was the average percent of all values within that hour?
Application.worksheetfunction.average(MyArray,1,14 )

Based on my different (random) attempts at syntax, I always get an error
about the number of dimensions, or a type mismatch error. I'v tried various
combinations of commas, parans, etc, but no joy.

Can anyone help me with the syntax to get this first calculation? From that,
I should be able to deduce the syntax pattern and do all the rest.

Thank you,
Keith
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Excel statistical functions on a subset of an array avi Excel Programming 2 January 8th 09 10:53 PM
Excel worksheet functions question. VegasBurger Excel Worksheet Functions 3 June 15th 06 06:23 PM
Worksheet name syntax question anny Excel Programming 4 February 8th 06 09:21 PM
How to enter symbols for subset or element of a subset in Excel? rwcita Excel Worksheet Functions 1 January 23rd 06 09:27 PM
Easy Syntax question: referring to worksheet by VBA name KR Excel Programming 2 November 22nd 04 07:53 PM


All times are GMT +1. The time now is 05:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"