Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching / Calculating Multi-Dem Arrays
I have two multi-dimensional arrays. I have two tasks I
am trying to perform. I am looping through ary1 and then ary2. 1. If the data in the ary2 matches the data in ary1 then I want to count the number of records in ary2 that match. The column that is key to both arrays can be different. 2. After counting the number of records I want to sum / avg the values of the records in ary2. I know I can accomplish this much easier in Access but this is what my client wants. Thanks, JohnV |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional IF formula using multi-dimensional arrays | Excel Worksheet Functions | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
Calculating Mode for multiple arrays based on criteria in another | Excel Worksheet Functions | |||
multi conditional searching | Excel Worksheet Functions | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) |