Count consecutive value in a range using formula

[Excel Fox]

You mean the maximum continuous occurrence of a given value? Or should the character that is repeating the most continuously should be displayed along with the maximum number?

[LalitPandey87]

You mean the maximum continuous occurrence of a given value? Or should the character that is repeating the most continuously should be displayed along with the maximum number?

Yes i mean the maximum continuous occurrence of a value based on criteria.

For Ex. :-

A

A

B

A

A

A

A

B

B

C

In above data range
if the criteria is "A" then the answer will be 4
if the criteria is "B" then the answer will be 2
if the criteria is "C" then the answer will be 1

[LalitPandey87]

Hi

Try this array formula

=MAX(FREQUENCY(IF(A1:H1=J1,COLUMN(A1:H1)),IF(A1:H1 <>J1,COLUMN(A1:H1))))

Where J1 houses A

HTH

Thanks Admin for your quick response.


This is exactly what i was lookin for.