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..