In some specific occasions, I have to display the correct value if I find a particular word inside a comment but only if this word is listed.
When I use the formula ?
To find the specific word inside a comment only if it is listed.
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 formula ?
=IF()
=SUMPRODUCT()
=ISNUMBER()
=SEARCH()
=IF(SUMPRODUCT(--ISNUMBER(SEARCH($A$2:$A$4,B2))),"yes","no")
This formula is telling me if in the cell B2, the words BR, CL or AR is listed in the column A.
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...