Helllo guys.
I am working with "unit cost compositions"; these compositions contain inputs (which are the lowest possible level) and/or may include auxiliary compositions. These auxiliary compositions contain inputs and/or may include other auxiliary compositions, and so on.
My goal is to ensure that only inputs remain. To achieve this, I need to multiply the index of the main composition by the index of the auxiliary composition.
I have achieved this goal in the attached file, but I would like to obtain the result more quickly, without having to follow a step-by-step process.
About the attached file:
In the attached file, in the "DATA" tab, which is my data input, I have the main composition in column "A", the input or auxiliary composition in column "B", and in column "C", the index/incidence of the item in column "B" within "A".
Through the step-by-step process in the following tabs, I reached the desired result in the "END" tab, between columns "E" and "G".
I appreciate your help.
https://docs.google.com/spreadsheets/d/16w67Hcevkc5R7JJSvyrMOpuQ4ekn385h/edit?rtpof=true&sd=true
I am working with "unit cost compositions"; these compositions contain inputs (which are the lowest possible level) and/or may include auxiliary compositions. These auxiliary compositions contain inputs and/or may include other auxiliary compositions, and so on.
My goal is to ensure that only inputs remain. To achieve this, I need to multiply the index of the main composition by the index of the auxiliary composition.
I have achieved this goal in the attached file, but I would like to obtain the result more quickly, without having to follow a step-by-step process.
About the attached file:
In the attached file, in the "DATA" tab, which is my data input, I have the main composition in column "A", the input or auxiliary composition in column "B", and in column "C", the index/incidence of the item in column "B" within "A".
Through the step-by-step process in the following tabs, I reached the desired result in the "END" tab, between columns "E" and "G".
I appreciate your help.
https://docs.google.com/spreadsheets/d/16w67Hcevkc5R7JJSvyrMOpuQ4ekn385h/edit?rtpof=true&sd=true