Is there any way of creating a filter condition that would be equal to all?
I would like to include all cells with and without cell content as a condition for one of my columns.
It would be something like this
=filter(A1:C4, B1:B4=F2, C1:C4=G2) F2=a & G2=’all’
I have set up a spreadsheet here
The reason why I want to do this is that my condition changes depenedent on other parameters and G2 could be ‘all’ or a specific condition like ‘t’ but it has cater for both situations.
>Solution :
I don’t know how to use the filter function but you can add a column that validates your conditions first, then filter on that column only, it would probably be easier
the formula for the validation column could look like this :
=if(and(B1=$F$2,or(C1=$G$2,C1="")),1,0)