Status | Bookmaker | Rating |
Win | Nitrogen Sports | Pick of the Day |
Loss | Nitrogen Sports | Regular |
Win | TRP Special | Pick of the Day |
Loss | TRP Special | Pick of the Night |
Win | TRP Special | Pick of the Day |
Win | TRP Special | Pick of the Night |
<tbody>
</tbody>
Alright, So I am trying to find the current Win Streak for "Pick of the Day". n this example it'd be 3 because Column A = Win AND Column C = Pick of the Day. However if you look for the current streak of Pick of the Night, it'd only be 1. I need formula to find Current and another formula to find Longest streak given two criteria...Criteria being Column A = Win and Column C = Pick of the Day(for this example)
I figure I'd have to use MAX and Frequency combo but I can't figure out how to incorporate them based on if two criteria are met. Thanks.