Calculating the maximum run of the same digit

[giantwolf]

Hi,

I am trying to find an equation that would count the maximum run of zero's in a row of data

eg)

a b c d e f g
1 1 0 1 0 0 1 = 2
0 0 0 1 0 1 1 = 3
0 1 1 1 0 1 1 = 1

each digit (1/0) is in a separate column but on the same row and whilst I can count the number of 0's in the row, I am having trouble finding counting the maximum run of zero's in each row.

Any help would be greatly appreciated.

Richard.

[DonkeyOte]

You can use a Frequency Array

Please Login or Register  to view this content.

(you might choose to add a pre-emptive COUNTIF test on 0 to ensure there is a streak to find in the first instance)

[giantwolf]

perfect, thank you very much for your help