finding matching rows
 

I have a large set of data (6 sheets each 10000 rows each containing 10
sets of 9 columns filled with integers) .
I want to compare the values of each set to a set of values and find out
how many sets (and what sets) contain 1, or 2, or 3 etc numbers that are
in the values to be compared.

Can I do this with existing Excel functions (Lookup, pivottables, sumif
etc??) or must I use VBA to do it?

If anyone has an idea how to use the Excel functions for this pls give
me a description HOW to do it
I also don't know what VBA-functions exit that could help me
(of course I know I can loop through all data and do everything myself,
but I suppose some built in functions would do teh job easier and faster)