Count number of blocks of code

[Saarahh]

Hello Excel community. I need to count the number of times a block of value appears in a column. That will be easier to understand with an example:
Blocks.png
I am struggling to find a formula that works. Do you have any idea as to how I could proceed?

[Richard Buttrey]

As presented then

E4 copied down

=COUNTIFS($A$2:$A$11,D4)/MAX(1,COUNTIFS($A$2:$A$10,D4,$A$3:$A$11,D4))

[Saarahh]

It works perfectly, thank you!

[Saarahh]

There are actually a few cases where it does not work. E.g., it returns a decimal value in this example for the count of "1" using the formula you suggested:
Attachment 735207

[FlameRetired]

Saarahh,

Richard's formula works fine at my end. Would you upload another file that behaves the way you described in post #4 please? That last attachment doesn't display for everyone.

[Rick Rothstein]

For your data layout, put this formula in cell E4 and copy it down...

=SUMPRODUCT(0+(A$2:A$11=D4),0+(A$3:A$12<>D4))

[wk9128]

E4 cell formula , drag it down