I am looking to count the number of consecutive values >=2 over 3 different rows.....I was helped greatly the other day on how to do this on a row, but since then I have been looking to get this to work over 3 rows.

Quote Originally Posted by daddylonglegs View Post
I assume you want the maximum number of consecutive values >= 2. For that try this formula

=MAX(FREQUENCY(IF(A2:R2>=2,COLUMN(A2:R2)),IF(A2:R2<2,COLUMN(A2:R2))))

confirmed with CTRL+SHIFT+ENTER
There will 3 different rows with 18 columns (golf database) so 1 row will be populated at a time. So ideally I would like to get daddylonglegs equation to work over A2:R2 & A4:R4 & A6:R6....this way it will calculate the for day one, then also take into account day 2 and then also day 3.

I have tried :-
=MAX(FREQUENCY(IF((A2:R2,A4:R4,A6:R6)>=2,COLUMN(A2:R2,A4:R4,A6:R6)),IF((A2:R2,A4:R4,A6:R6)<2,COLUMN(A2:R2,A4:R4,A6:R6))))

Error I believe is to do with the Cloum part, but I do not fully understand it all.