| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting rows with 3 columns | Excel Worksheet Functions | |||
| Listing Multiple Rows from Match | Excel Worksheet Functions | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Threaded Mode
