Hi,
I have such a complexity matrix for a product table. Every time I update the table, I'd like to do a final check to see if the all assemblies are marked properly, so that they are pulling at least one "Part" from each Product Group in below table. Depending the usage, I want to concatenate part names (Part1,2,3...) with sumproduct functionality as below in red.
How can I use Sumproduct & Concatenate functions to form such string?
<tbody>
</tbody>
I have such a complexity matrix for a product table. Every time I update the table, I'd like to do a final check to see if the all assemblies are marked properly, so that they are pulling at least one "Part" from each Product Group in below table. Depending the usage, I want to concatenate part names (Part1,2,3...) with sumproduct functionality as below in red.
How can I use Sumproduct & Concatenate functions to form such string?
Assembly1 | Assembly2 | Assembly3 | ||
Group1 | Part1 | 1 | ||
Group1 | Part2 | 1 | ||
Group1 | Part3 | 1 | ||
Group2 | Part4 | 1 | ||
Group2 | Part5 | 1 | ||
Group2 | Part6 | 1 | ||
Group3 | Part7 | 1 | ||
Group3 | Part8 | 1 | ||
Group3 | Part9 | 1 | ||
Group4 | Part10 | 1 | ||
Group4 | Part11 | 1 | ||
Group4 | Part12 | 1 | ||
Check | Part1Part4Part7Part10 | Part3Part5Part8Part12 | Part2Part6Part9Part11 | |
<tbody>
</tbody>