Count number of times an event occurs between recurring events

[Napoleoncarrot]

I am trying to count how many times an event (over pressure) occurs between a recurring event (start), I have >10000 entries. My column looks like,

start
over pressure
over pressure
start
over pressure
start
over pressure
over pressure
start
start
start
over pressure
start

In some instances no over pressure is detected
Ideally I'd like the output to read for this example to read
0
1
2
0
1
0
1
2
0
0
0
1
0

 

[Eric W]

Welcome to the board.

Maybe:

	A	B
Event	Count
start
over pressure
over pressure
5	start
over pressure
start
over pressure
over pressure
start
start
start
over pressure
start

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]0[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"]0[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]0[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]0[/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]0[/TD]

[TD="align: center"]12[/TD]

[TD="align: right"]0[/TD]

[TD="align: center"]13[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]14[/TD]

[TD="align: right"]0[/TD]

</tbody>

Sheet8​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B2[/TH]
[TD="align: left"]=IF(A2="start",0,SUM(B1,1))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[hotabae]

If I could piggy back off of Eric Above, I did it using a manually typed 0 in B2, with this formula in B3 and below (dragged down):

=IF(A3="over pressure", B2+1,0)

Edit: also... fun fact: turns out I was also working off of my Sheet8 xD

 

[Napoleoncarrot]

Thanks exactly what I needed.

 

[Eric W]

Glad we could help.