Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel Worksheet functions in Arrays
I have populated a multidimensional array, part of which is exampled as
follows: JAN05 Q105 45.3 12.5 16.6 88.9 etc FEB05 Q105 55.6 23.6 58.4 65.2 MAR05 Q105 25.7 36.5 98.5 45.7 APR05 Q205 98.4 25.7 23.9 59.7 MAY05 Q205 39.5 56.8 89.2 25.7 etc I want to be able find and average all numbers in a particular column that match a designation in Column 2, eg Q105, in the array. This array is not populated in a worksheet, and nor do I want it to be. I can do this by looping through every row in the array for a specific column, but the array is 150 rows by 20 columns but it seems a cumbersome approach. Can I do this using the Dbase Worksheet functions that can be used in VBA ? Advice appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Functions/arrays | Excel Discussion (Misc queries) | |||
Which Excel Functions Require Arrays to be Sorted? | Excel Worksheet Functions | |||
Excel functions which support arrays (SHIFT-CNTRL-ENTER)? | Excel Worksheet Functions | |||
Linking worksheet functions and arrays - Doozie | Excel Discussion (Misc queries) | |||
Arrays parameters in Functions | Excel Worksheet Functions |