I am trying to figure out 'longest winning' streak. Currently page 2 has column that has either y or n in in cell. Y represents win and N represents loss. What I am trying to do is count most consecutive y in column - between the loss (N) Currently column is filled with y or n - just want the max count of wins, if that makes sense.

Thanks,
Jack