Compare 2 Arrays

There are many arrays in a table. I'm basically experimenting with using Excel to solve some puzzles. I'm wondering if I'd have been better off doing it with PHP since that's my forte.

Basically, there are 9 arrays in L2:T2 through L10:T10 (stacked on top of each other) and another 9 in B12:B20 through J12:J20, alongside each other. Where they all meet (ie between B2 and J10) is where I want the comparison doing.

Does that help?

Sounds like they are basically cell values that you are calling an array?
You could pass the ranges to the sub and use the ranges as the arrays.

You may want to post an example workbook.

You may also want to look at the Intersect method

http://msdn.microsoft.com/en-us/library/bb209961.aspx