Best Win Streak / Current Win Streak

Hi All,

I am running a table where i want to tally the best streak over a date. I have this formula and it is working fine. 1 donates a win 2 donates a loss and 3 donates a day to skip for the streak. However i am having trouble figuring out how to tally a players current streak. In the attached data the player has a best win streak of 4 over the period. However i would like to show his current unbroken streak which is 2 wins. Any help would be greatly appreciated.

Please try with Ctrl+Shift+Enter

=LOOKUP(9^9,FREQUENCY(IF(C4:Q4=1,$C$2:$Q$2),IF(C4:Q4>1,$C$2:$Q$2)))

Please note:

To mark a thread as solved, please select Thread Tools from the menu link above and mark this thread as SOLVED. I will amend this for you this time.

Also (sorry!) please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.