Friday, May 6, 2011

yogi_Count Objects In An Array Tthat Match Another Array In Different Size

Yogi Anand, D.Eng, P.E.                                 Google Spreadsheet          
Santiago said:
Count objects in an array that match another array in different size.
I'm working on a dashboard and I have 2 arrays. One with unique values and another one with many values that match the first array. I want to know how many values in the second array match the values in the first array. I know how to do this on VBA, but I'm not allow to use it.
Here is the example:
here, the result of what I want would be 6 (3 a, 2 b and 1 c)
I appreciate any help.
Following is a solution is Sheet1 using Google Docs Spreadsheet