Great video tutorials.
I am using FILTER function, where I define array and use multiple criteria that I want to use as filter for my result. Let say I use Country, Company and Year criteria to filter my data. Criteria is read from another cell where I have dropdown field with all possible values. It all works fine if I select for example Sweden, Volvo and 2021.
I would like to be disregard one of the three criteria's that I am using. So for example if I want to see Sweden, Volvo and then to see values for all years, what do I do. I know I can change formula to just use two criteria's instead of three, however I am looking for potential easier solution. I would like to enter something like % or * in the year criteria field to give me ALL values (in other words disregard that criteria).
Anyway to accomplish that?
I am using FILTER function, where I define array and use multiple criteria that I want to use as filter for my result. Let say I use Country, Company and Year criteria to filter my data. Criteria is read from another cell where I have dropdown field with all possible values. It all works fine if I select for example Sweden, Volvo and 2021.
I would like to be disregard one of the three criteria's that I am using. So for example if I want to see Sweden, Volvo and then to see values for all years, what do I do. I know I can change formula to just use two criteria's instead of three, however I am looking for potential easier solution. I would like to enter something like % or * in the year criteria field to give me ALL values (in other words disregard that criteria).
Anyway to accomplish that?
