Hi guys,
I need to calculate the longest streak and average streak of an outcome from a set of football results.
Can anyone help me work out the formula to measure the longest winning streak and average winning streak and losing streaks for “h”(home win)?
I have uploaded a pic of what I mean...
Thanks
Bookmarks