Mucus -blood Stool Years Pain

Count maximum number of consecutive values \u200b\u200b

In A1: A10 data, in B1 the value you want to analyze.
The array formula below returns the maximum number of consecutive cells that contain a value equal to that in B1

= MAX (FREQUENCY (IF (A1: A10 = B1, ROW (A1: A10)), IF (A1 : A10 <> B1, ROW (A1: A10))))

A variant can count the maximum number of empty cells (or empty or contain ")

= MAX (FREQUENCY (IF (A1: A10 =" ", ROW (A1: A10)), IF ( A1: A10 <> "", ROW (A1: A10))))

more ... same evaluation on multiple parameters, but ...
data in A1: B10 ... C1 and D1 parameters in this formula:

= MAX (FREQUENCY (IF ((A1: A10 = C1) * (B1: B10 = D1), ROW (A1: A10)), IF ((A1: A10 = C1) * (B1: B10 <> D1), ROW (A1: A10))))

returns the maximum number of consecutive values \u200b\u200bfulfilling the conditions:
A1: A10 equal to C1 and B1: B10 equals D1

greetings R