Forum Discussion
Solved
Filter for Non Adjacent Columns, and make the columns dynamic.
Hi,
I Followed this video, and it works perfect But i can not find out how to make which columns i use dynamic.
The formula =FILTER(FILTER(t_årshjul;t_årshjul[Måned]="Jan");{1\0\1\1\0})
Selects the right columns {1\0\1\1\0}, but how do I make that reference dynamic, so I can use the values from H3 as the selections for which columns I would like to display.
Best Regards
- Geir
Hogstad_Raadgivning Replace the hard-coded list of ones and zeroes by a reference to C3:G3
=FILTER(FILTER(t_årshjul;t_årshjul[Måned]="Jan");C3:G3)
2 Replies
Hogstad_Raadgivning Replace the hard-coded list of ones and zeroes by a reference to C3:G3
=FILTER(FILTER(t_årshjul;t_årshjul[Måned]="Jan");C3:G3)
- Thank you. That was so simple that I never tried that. Brilliant.
