Thanks so much for your solution. I countinued to try and solve my
issue and came up with another method. Both seem to have their pros
and cons.

In my solution, I made another matrix that counts which numbers come up
in each data set. Then I did a sumproduct for each pair. See the
attached zip spreadsheet.

Thanks again!


+-------------------------------------------------------------------+
|Filename: matching pairs.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3732 |
+-------------------------------------------------------------------+

--
bmb2200
------------------------------------------------------------------------
bmb2200's Profile: http://www.excelforum.com/member.php...o&userid=26560
View this thread: http://www.excelforum.com/showthread...hreadid=398319