Good afternoon and congratulations for the great job that you are doing.

I have a problem about counting the delays of some values ​​in a set of many cells.

I have a bar and I want to figure out how many orders is delaying an order with tequila. With simple words i want to count the distance which is separating the one order with tequila from the other.

Whenever I have an order with tequila I put "YES" and every time i have an order without tequila i put "NO".

The image of the column is like this
1. YES
2. NO
3. NO
4. NO
5. YES
6. NO
7. NO
8. NO
9. NO
10. NO
11. YES

So finally, I want to count each time the distance between "YES", and don't do it with my finger

Thanks in advance for your help