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.
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.
Bookmarks