NB.SI with partial text
Solved
nice
-
nice -
nice -
Hello,
I need your help regarding a detail about the COUNTIF function.
When I want to check if a range contains certain text (typed manually), the function works well.
--> Example: =COUNTIF(F2:F108,"*University initial training*")
However, when instead of typing manually, I want to refer to the cell that contains the same text, it doesn't work completely.
--> Example: =COUNTIF(F2:F108,A37)
Indeed, when the phrase in the range ends with a period, comma, or other punctuation, it isn't counted... I would like it to be. How can I do that?
It's not easy to explain, I hope I am understood.
Thank you in advance for your help.
I need your help regarding a detail about the COUNTIF function.
When I want to check if a range contains certain text (typed manually), the function works well.
--> Example: =COUNTIF(F2:F108,"*University initial training*")
However, when instead of typing manually, I want to refer to the cell that contains the same text, it doesn't work completely.
--> Example: =COUNTIF(F2:F108,A37)
Indeed, when the phrase in the range ends with a period, comma, or other punctuation, it isn't counted... I would like it to be. How can I do that?
It's not easy to explain, I hope I am understood.
Thank you in advance for your help.
1 answer
-
yg_be Posted messages 23437 Registration date Status Contributor Last intervention Ambassadeur 1 588
Hello, what did you put in A37?
Can you give some examples?
Maybe:=COUNTIF(F2:F108,"*"&A37&"*")
