count if a condition met

[mushtf]

Hi All,

I am trying to figure out a formula that I can use to count if the 5 consecutive rows in a column have the same value e.g the data set below has 1x4 times, 2x5 times, 3x5 times and 4x3 times so it should give me an answer 2.
Any help?

1
1
1
1
2
2
2
2
2
3
3
3
3
3
4
4
4

[jewelsharma]

try this array formula:

=SUM(IF(FREQUENCY(A1:A17,A1:A17)=5,1))

An array formula must be entered as Ctrl + Shift + Enter

HTH!