When I was doing multiple filters in my main sheet, I created a new sheet in order to separate them so I didn’t need to filter again. For instance, 1 filter for all CIs in France so pasting it in 1 new sheet and another one for Germany pasting it in another new sheet. In case if I wanted to have all in the same main sheet, I used this formula by adding new columns.
When I use the formula ?
After filtering in the main sheet, instead to create a new sheet to paste the result, using this formula to have the result in the same sheet.
How to use the formula ?
The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".
How are the formulas ?
Put this formula:
So I am asking to display the name of the CI for all values except if “no”.