linking across matrices

4.85K viewsFormulas and Functions

How do you link a line on one matrix to the workings on another when the workings has 2 working tablets, i.e. total, then 2 lines and a sub total in the next field, when I make one equal the total, it only brings up the top line in the next field, not the subtotal at the bottom. Is there a skip style mechanism?



I created a dummy example of what I think (but I may be wrong) you are looking for.

Matrix1 is the input matrix inlcuding the categories Total First Year Trail and Positions.

Matrix2 is the first solution where all categories are linked. Then you see all the details including each position. You can collapse the positions or hide them.

Matrix3 is another solution where only the first two categories are linked. You can see here that the formula to get the sub totals is slightly more complex.

All the best,

You are viewing 1 out of 4 answers, click here to view all answers.