Forum Discussion
Solved
FILTER Function using a cell reference as a Boolean for the Include parameter
Hello Experts, I've created a concatenated field to retrieve the boolean expression to be used in a FILTER function as below: A1 = "{"&B1&","&C1&","&"}" OR {1,0,1} A2 = 1 So, my formula i...
I usually just include a field above my table containing TRUE/FALSE to indicate which columns to include:
=FILTER(FILTER(D5:F20;(A5:A20=A2));D4:F4=D1:F1)Maybe like this. In cells D1, E1 and F1 you can enter "D", "E" or "F" in order to dynamically return the chosen columns in the spilled range.