Hi,
I have been trying everything to combine similarity matrices, but cannot get the code to work. I have blank matrix that needs to be filled in with the sum of the cells in all of the above matrices. I pasted below an example of what I mean. The number in brackets on the bottom matrix are what the data SHOULD be...not what I actually have successfully written code for.
The data is symmetrical, and each matrix repeats on every 10th line. I tried doing the operation from an earlier question (to sum every nth line), but could not get it to work. Maybe because the txt got in the way? I'm so lost and desperate! If it helps at all, this is the code I was using that I couldn't get to work...
=SUMPRODUCT((MOD(ROW($B$3:$B$29),10)=0)*($B$3:$B$29))
My data looks like this (except a LOT more cases)! THANK YOU SO MUCH!!!
____________________________________________________________________________________________
<tbody>
</tbody>
I have been trying everything to combine similarity matrices, but cannot get the code to work. I have blank matrix that needs to be filled in with the sum of the cells in all of the above matrices. I pasted below an example of what I mean. The number in brackets on the bottom matrix are what the data SHOULD be...not what I actually have successfully written code for.
The data is symmetrical, and each matrix repeats on every 10th line. I tried doing the operation from an earlier question (to sum every nth line), but could not get it to work. Maybe because the txt got in the way? I'm so lost and desperate! If it helps at all, this is the code I was using that I couldn't get to work...
=SUMPRODUCT((MOD(ROW($B$3:$B$29),10)=0)*($B$3:$B$29))
My data looks like this (except a LOT more cases)! THANK YOU SO MUCH!!!
____________________________________________________________________________________________
ID_350 | Brother | Father | Uncle | Cousin | Grandson | Son | Nephew | Godfather |
Brother | ||||||||
Father | 0 | |||||||
Uncle | 2 | 1 | ||||||
Cousin | 0 | 4 | 0 | |||||
Grandson | 1 | 2 | 2 | 1 | ||||
Son | 3 | 1 | 1 | 2 | 4 | |||
Nephew | 1 | 1 | 2 | 1 | 4 | 4 | ||
Godfather | 0 | 6 | 3 | 3 | 4 | 0 | 3 | |
ID_351 | Brother | Father | Uncle | Cousin | Grandson | Son | Nephew | Godfather |
Brother | ||||||||
Father | 1 | |||||||
Uncle | 3 | 0 | ||||||
Cousin | 3 | 1 | 2 | |||||
Grandson | 2 | 1 | 4 | 2 | ||||
Son | 3 | 2 | 1 | 3 | 4 | |||
Nephew | 2 | 2 | 2 | 1 | 3 | 1 | ||
Godfather | 2 | 2 | 1 | 2 | 2 | 2 | 2 | |
Aggregate | Brother | Father | Uncle | Cousin | Grandson | Son | Nephew | Godfather |
Brother | ||||||||
Father | [1] | |||||||
Uncle | [5] | |||||||
Cousin | [3] | |||||||
Grandson | [3] | |||||||
Son | [6] | |||||||
Nephew | [3] | |||||||
Godfather | [2] |
<tbody>
</tbody>