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
Bookmarks