Count Max Times a Number Continiously Repeated

**Azam Ali** · 10-13-2011, 05:48 AM

Hi all
I want to calculated maximum times a number is continuously repeated in a column without a helper column
see attach file

thanks in advance

**Andrew-R** · 10-13-2011, 06:02 AM

In cell G5 put the formula =MAX(FREQUENCY(IF(A2:A37=$G$4,ROW(A2:A37)),IF(A2:A37<>$G$4,ROW(A2:A37))))

You must use Ctrl-Shift-Enter when you put this formula in, not just enter.

Much kudos to NBVC, who told me how to do this.

**MUSTAFAINE** · 10-13-2011, 06:57 AM

good solve, thanks.

**bebo021999** · 10-13-2011, 07:21 AM

Originally Posted by Andrew-R

In cell G5 put the formula =MAX(FREQUENCY(IF(A2:A37=$G$4,ROW(A2:A37)),IF(A2:A37<>$G$4,ROW(A2:A37))))
You must use Ctrl-Shift-Enter when you put this formula in, not just enter.
Much kudos to NBVC, who told me how to do this.

Thanks Andrew for excelent solution
Thanks Azam Ali for helping me to raise new thread.