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 ?
=IF()
=NOT()
=OR()
Put this formula:
=IF(NOT(OR(C3="no")),A3,"no")
So I am asking to display the name of the CI for all values except if “no”.
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...