Winning Streak by Month...

If I have the following data...

JAN W
JAN W
JAN L
JAN W
JAN L
JAN L
JAN L
JAN W
JAN W
JAN W
JAN W
FEB W
FEB L
FEB L

Is it possible to get the largest winning streak for any month? For example, in JAN it would be 4. Typically, I'll have about 1,000 entries per month.

Sick skills... The formula was awesome.

MAX(FREQUENCY(IF(A1:A3000<0,ROW(A1:A3000)),IF(A1: A3000>=0,ROW(A1:A3000))))


What about if I try to figure out the consecutive streak per month? Let's say that the month is in COL A, the result is in COL B....

Assuming month is text not a formatted date try this formula

=MAX(FREQUENCY(IF(A1:A100="Jan",IF(B1:B100="W", ROW(A1:A100))),IF(A1:A100="Jan",IF(B1:B100<>"W", ROW(A1:A100)))))

confirmed with CTRL+SHIFT+ENTER

Daddylonglegs,

You are the closest I have come to blasphemy...

Sik, sik, sik...

I know you don't get any sleep; I know what you do when you sit on the toilet; I know what you dream about; I know what you talk to your mate about.

Obviously, the formula worked. Thanks.

-Erick

Now Erick.......

Yes, it's certainly a thing of great beauty........but it's still only a formula, don't get carried away.......