Calculate longest winning streak using google spreadsheets

[yonifx]

Hi,

I'm trying to create a winning streak formula like in my excel but when i press CTRL+SHIFT+ENTER it doesn't work like in excel, it only adds ARRAYFORMULA before my formula and gives me ERROR..

Any ideas what to do?

I really don't have to use ARRAYFORMULA, just want to find the formula that calculates the longest winning streak.
Streaks.JPG

[AliGW]

Continue in your original thread, please: https://www.excelforum.com/for-other...ng-streak.html

Duplicate threads are not allowed.