Searching / Calculating Multi-Dem Arrays

J

JohnV

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-Dimensional Array 17
Dealing with unknown array sizes 7
append multiple worksheets data into a single multi-dimensional array 4
Multi-Dimensional Array Procedures 2
Help with multi dim arrays 3
Returning an array from a multi-dimensional array 2
Array formula does not calculate correctly when run from macro 14
Array - retrieve certain amount of recods for query 0

Top