How to count consecutive text occurrences in a column?

[rageagainstjg]

Hello all,
Column A has entries that can be Y, N, or W. I want column B to count the number of consecutive occurrences of either Y, N or W, as you work your way down the column. An example of what I want is shown at the link. What I need is the formula for column B, manually entering it sucks!

https://imgur.com/a/kFMJlYA

Thank you for any help you can provide.

 

[Micron]

Maybe drag down from A2: =IF(A1=A2,B1+1,1)
You would have to enter 1 in A1 though.

 

[rageagainstjg]

Maybe drag down from A2: =IF(A1=A2,B1+1,1)
You would have to enter 1 in A1 though.

You have hit the nail on the head perfectly! thank you!

I now have another problem, a time problem, would you be willing to look at this question?

I am attempting to calculate how long consecutive occurrence instances happened. So with that being said please look at this link and know that column “D” is the one I need the formula for

https://imgur.com/a/j9NItib

 

[Micron]

Sorry, that one is out of my league. Looks like some sort of Max minus Min over groups of Y's or N's.

 

[Peter_SSs]

In any case you have duplicated this latest question. How to count time if value is present?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.