Hello
I have a formula for calculate Max Consecutive "Win" in the Column A:A
{=MAX(FREQUENCY(IF(A:A="Win",ROW(A:A)),IF(A:A="Loss",ROW(A:A))))}
Formula is Correct, but I need ignore Hided Rows :
A2 = Win
A3 = Win
A4 = Win
A5 = Loss
A6 = Win
A7 = Win --> Hided
A8 = Win --> Hided
A9 = Win
A10 = Loss
Max Consecutive "Win" = 4
but I Hided A7 and A8 then in this situation Max Consecutive "Win" =3
Please look at my attach file
Thank you in advance for your answer
Bookmarks