MAX Consecutive across columns

Originally Posted by williampdx

Are there other options for coming up with the same information using an array?

Realistically given your data you would need to create a contiguous listing and work from that.

Using your sample file... insert a new sheet, name it "Data" and add following headers:

A1: Date
B1: +/-
C1: Sign

Then

A2:
=IF(MOD(ROWS(A$2:A2)-1,7),A1,INDEX('COR Table'!$B:$B,3+CEILING(ROWS(A$2:A2)/7,1)+CEILING(ROWS(A$2:A2)/35,1)-1))

B2:
=INDEX('COR Table'!$A:$BF,3+CEILING(ROWS(A$2:A2)/7,1)+CEILING(ROWS(A$2:A2)/35,1)-1,9+8*MOD(ROWS(A$2:A2)-1,7))

C2:
=IF(B2=0,N(C1),SIGN(B2))

copy A2:C2 down to row 1191 (to cover your 1190 data points)

With the above in place your "streak" calculations can be based off the above data set with relative ease:

Wins:
=MAX(FREQUENCY(IF(Data!$C$2:$C$1191=1,ROW(Data!$C$2:$C$1191)),IF(Data!$C$2:$C$1191<1,ROW(Data!$C$2:$C$1191))))
confirmed with CTRL + SHIFT + ENTER

Losses (as above but using -1 and > test):
=MAX(FREQUENCY(IF(Data!$C$2:$C$1191=-1,ROW(Data!$C$2:$C$1191)),IF(Data!$C$2:$C$1191>-1,ROW(Data!$C$2:$C$1191))))
confirmed with CTRL + SHIFT + ENTER

Based on the sample data I believe the answer for both calculations is 24, correct ?