Forum Discussion
Solved
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 l...
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!