Hello, I'm a beginner user and the problem is when I have a lot of data in the A column (2 possible values: "yes" or "no").
How I can count how many times value "no" is appeared in series?
The result can be stored in column C (see uploaded file).
For example:
yes
yes
no 1
yes
no
no
no 3
yes
yes
no
no 2
yes
etc.
Do I need to use array formulas or not?
What function can solve this kind of problems?
Excel file with example is uploaded.
Bookmarks