Count consecutive value in a range using formula

[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