Maximum Consecutive wins OR How maximum times, an Event has occurred Consecutively (Using Frequency Function)
Hi Everyone, This time, I have come up an excel function which will give you maximum consecutive Wins count for different teams. To be more precise, this article is gonna be about finding maximum consecutively occurring event OR we can say that how maximum times, an event has consecutively occurred. The Function I have used, uses Frequency function in its core. To start with explaining the Win part, I have used following Formula to calculated consecutive wins count for team Say India:-