[TABLE="width: 363"]
<tbody>[TR]
[TD="colspan: 2"]Status[/TD]
[TD]Bookmaker[/TD]
[TD]Rating[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Win[/TD]
[TD]Nitrogen Sports[/TD]
[TD]Pick of the Day[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Loss[/TD]
[TD]Nitrogen Sports[/TD]
[TD]Regular[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Win[/TD]
[TD]TRP Special[/TD]
[TD]Pick of the Day[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Loss[/TD]
[TD]TRP Special[/TD]
[TD]Pick of the Night[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Win[/TD]
[TD]TRP Special[/TD]
[TD]Pick of the Day[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Win[/TD]
[TD]TRP Special[/TD]
[TD]Pick of the Night[/TD]
[/TR]
</tbody>[/TABLE]
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.
<tbody>[TR]
[TD="colspan: 2"]Status[/TD]
[TD]Bookmaker[/TD]
[TD]Rating[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Win[/TD]
[TD]Nitrogen Sports[/TD]
[TD]Pick of the Day[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Loss[/TD]
[TD]Nitrogen Sports[/TD]
[TD]Regular[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Win[/TD]
[TD]TRP Special[/TD]
[TD]Pick of the Day[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Loss[/TD]
[TD]TRP Special[/TD]
[TD]Pick of the Night[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Win[/TD]
[TD]TRP Special[/TD]
[TD]Pick of the Day[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Win[/TD]
[TD]TRP Special[/TD]
[TD]Pick of the Night[/TD]
[/TR]
</tbody>[/TABLE]
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.