I would do that with VBA but perhaps someone else can come up with an array
formula for you.
In VBA, you would write code to loop through each row of your 10000 rows.
Within this loop, you would have a second loop through the sorted array of
8. The inner loop would come up with the number of "hits" for each row and
place that number in the 10th column. Does that sound like something you
want? Post back if you need more. HTH Otto
"JackRnl" wrote in
message ...

I have a sorted array (8 integer elements) and a large matrix (10000, 9)
and would like to know how many elements of my sorted array occur in
each row of my matrix and put that count (for each row) in an integer
array Present(10000)

Must i compare each element of my sorted array with each element of
each row of my matrix (OK, I can do it "intelligent" and skip part of
the comparisons), or does a function exist that allows me to do that
more efficient. Ideal would be for the whole matrix at once of course.


--
JackRnl
------------------------------------------------------------------------
JackRnl's Profile:
http://www.excelforum.com/member.php...o&userid=37172
View this thread: http://www.excelforum.com/showthread...hreadid=570095