Forum Discussion
Filter columns by criteria, dynamic spilled/list.
Hi,
For each row in a dynamic range, I want to filter/select the headers if it is a "X" in the line column.
I made it work with Filter. But I dont get that to be dymamic for each row in the list.
=TAKE(FILTER($T$8:$AD$10;'Ark1'!T23:AD23="x";"");1)
Filter might not be right function here. Any better solutions?
Best regards
Geir
I would use SWITCH to obtain the headings and then go BYROW to string up the text (if more than 1 heading for each row).
=LET( M, SWITCH(grid, "X", header, ""), BYROW(M, LAMBDA(each_row, TEXTJOIN(", ", , each_row))) )
I would use SWITCH to obtain the headings and then go BYROW to string up the text (if more than 1 heading for each row).
=LET( M, SWITCH(grid, "X", header, ""), BYROW(M, LAMBDA(each_row, TEXTJOIN(", ", , each_row))) )- Perfect, thank you.
- Glad to help. You're welcome!
