I would like automate a sheet template which will be used by others guys with specific datas. In order to be more understandable, here after the link to my sheet example, for sure my official file are very, very more complexed: https://docs.google.com/spreadsheets/d/1UyW12WwG9sJUF0ZhnHGP9adgbY3xWUpj4kM9-ASN2WE/edit?usp=sharing
Due to these specific datas, I would like that each guy filled a header Management table (sheet Chart 1 range A4:F4 and sheet Chart 2 range A4:F4), and the formula build automatically the table in field I4 of the sheets Chart 1 & Chart 2.
I hope that my explanations are enough and clear, and I cross my finger that you will help me to find a solution which will be automated.
Thanks in advance. Regards. Vincent
Added solution to sheet here:
=LAMBDA(aix;MAP(INDEX(aix;;1);INDEX(aix;;2);INDEX(aix;;3);LAMBDA(ax;bx;cx;{ax\bx\cx\BYCOL(Datas!I:K;LAMBDA(ijk;SUMIFS(ijk;Datas!D:D;ax;Datas!E:E;bx;Datas!F:F;cx)))})))
(INDEX(SPLIT(FLATTEN(FLATTEN(FILTER(A5:A15; A5:A15<>"")&"|"&TRANSPOSE(FILTER(B5:B15; B5:B15<>"")))&"|"&TRANSPOSE(FILTER(C5:C15; C5:C15<>"")));"|")))