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\...
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)
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.
