appears a consecutive series

[Dumy]

Can anyone give me the formula for counting consecutive series.
Question: How many times appears a consecutive series in the same row

No Item1 Item2 Item3 Item4 Item5 Item6 Item7 Item8 Item9 Item10 Actual result
1 A A B B B A C 2
2 100 0 0 200 200 200 11 1
3 252 131 700 700 151 1
4 1 1 7 2 2 3 4 4 4 3

But, ignore zero value or empty cell

example attached file

[newdoverman]

Here is one way. I created a "duplicated range" that only counted when a value was duplicated along the row regardless of the number of identical items that were in a row.

Please Login or Register  to view this content.

Then sum the 1s created by that duplicated range:

Please Login or Register  to view this content.

This is how it came together on a worksheet
There is probably a better way of doing this.

[Dumy]

Here is one way. I created a "duplicated range" that only counted

Thank you for your appearance and response.
This is a solution with extra columns.

Is there a possibility to solve counting using a single formula in a one cell?

[sourabhg98]

If a value appears consecutively more than once in the same row, should it be counted as 2 occurrences or just one, if just one occurrence then the above formula is perfect, however if it needs to be 2 then --
=IF(AND(B2=A2,B2<>C2),1,"") this would be enough..

[sourabhg98]

If you don't want many columns One formula can be
=SUM(IF(B2:K2=A2:J2,IF(B2:K2<>C2:L2,1,"")))
in cell M2 copied down..
However, it an array formula so to use it just press ctrl+shift+enter instead after just enter after pasting this formula in the cell...
note-this is for the second case i.e. counting twice

[ChemistB]

Try this

=SUMPRODUCT(--($B2:$J2=$C2:$K2), --($A2:$I2<>$B2:$J2), --($B2:$J2>0))

[sourabhg98]

Oops I forgot to skip blanks...however formula by ChemistB is perfect...

[Dumy]

If you don't want many columns One formula can be
=SUM(IF(B2:K2=A2:J2,IF(B2:K2<>C2:L2,1,"")))

Thank you for answer
This array formula does not work well. Returns wrong results

This is results which I need in M column
2
1
1
3

[Dumy]

Try this

Thank you for answering this is the correct formula for me, my regards

[Dumy]

Try this
=SUMPRODUCT(--($B2:$J2=$C2:$K2), --($A2:$I2<>$B2:$J2), --($B2:$J2>0))

Why this formula does not work on my second example

[Dumy]

Can somebody help me?

[sourabhg98]

then use this in AG1-
=SUMPRODUCT(--($B2:$AE2=$C2:$AF2), --($A2:$AD2<>$B2:$AE2), --($B2:$AE2>0),--($B2:$AE2<>""))
and copy down..

[Dumy]

then use this in AG1- ............and copy down..

Thank you very much @sourabhg98