Hello,
I am working on a matchmaking excel sheet to match different members of our community with another, based on similar interests, goals & industries. In order to match them, I used a sum product formula: =SUMPRODUCT(--($B12:$BK12=$B2:$BK2)*($B12:$BK12<>"")). The outcome is a matrix with two axes that shows the number of exact matches in their answers.
For now, if I add people, I have to manually change the formula. In order to "automatise" the matchmaking process as much as possible, I would like to change the formula in a way so that I can just drag it over to new people added, probably by adding "$" at the right positions. So far, I haven't managed to place them correctly. I would really appreciate your help, also happy about other suggestions on how to improve my matchmaking sheet.
Thanks,
Maria
Bookmarks