samedi 2 janvier 2021

Getting ticked header values using formula in Google sheets or excel

I have a table where I need to get the values of the ticked headers as shown. The ALL takes precedence and it will include all headers when ticked.

Here is the working copy of the sheet.,

The expected values are shown in the image below.

The purple cells will have formula, H2, H3 and so for for each row.

enter image description here I have tried with

=TRANSPOSE(FILTER(Config!A$1:A$16,(INDEX(Config!A$1:G$16,,MATCH(2,Config!$A$1:$1,0) ))=TRUE))

Aucun commentaire:

Enregistrer un commentaire