You're welcome ! Glad to hear that you found a solution to your problem,
and thanks for sharing it with us. Good luck with the game <g !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"bmb2200" wrote in
message ...
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