Put this result if not this value with a formula in an excel report

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.

macro excel


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”.

Interesting Management