Jan 19 2023 06:01 AM
Hello!
I'm trying to count the occurrence a term appears in a column. I tried with the =NB.SI.ENS formula but it seems only counting the cells countaining the only word (it doesn't work with the cells having the word among others).
Example: in the cells, I may have written two words: an action (substitution / ajout / suppression / déplacement) and a category (lexique / temps / expression, etc.). Therefore, a cell may contain "substitution lexique", and I would like to count those having "substitution" whatever words come after.
Does anyone would know how to help me?
Thank you very very much in advance!!
Jan 19 2023 06:13 AM
=NB.SI(A1:A100; "*substitution*")