Longest Winning Streak

[broncos347]

I have a spreadsheet where I track horse races. I have one column where I track wins and losses. Is there a formula which will tell you what is the current longest winning streak or losing streak?

 

[Aladin Akyurek]

I have a spreadsheet where I track horse races. I have one column where I track wins and losses. Is there a formula which will tell you what is the current longest winning streak or losing streak?

Here is a thread on the issue:

http://tinyurl.com/2lyyv6

 

[Domenic]

Assuming that A2:A100 contains the data, and that a win and a loss are recorded as W and L, respectively, try...

=MAX(FREQUENCY(IF(A2:A100="W",ROW(A2:A100)),IF(A2:A100<>"W",ROW(A2:A100))))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

 

[broncos347]

Domenic, works a treat thanks.

 

[BigBubba]

Assuming that A2:A100 contains the data, and that a win and a loss are recorded as W and L, respectively, try...

=MAX(FREQUENCY(IF(A2:A100="W",ROW(A2:A100)),IF(A2:A100<>"W",ROW(A2:A100))))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

Question: I need a winning streak formula for currency trades, I changed the "w" to >0 but result comes back a 1, when the longest streak of positive numbers is 6?

 

[Aladin Akyurek]

Question: I need a winning streak formula for currency trades, I changed the "w" to >0 but result comes back a 1, when the longest streak of positive numbers is 6?

Control+shift+enter:

=MAX(FREQUENCY(IF(A2:A100>0,ROW(A2:A100)),IF(A2:A100<=0,ROW(A2:A100))))

Equally...

=MAX(FREQUENCY(IF(SIGN(A2:A100)=1,ROW(A2:A100)),IF(1-(SIGN(A2:A100)=1),ROW(A2:A100))))

 

[BigBubba]

Ok I've tried the first formula, maybe my problem is my data is on another worksheet in this workbook here is what I have doesn't work but here it is

=MAX(FREQUENCY(IF(alveo statsP2:P3548>0,ROW(alveo statsP2:P3548)),IF(alveo statsP2:P3548<=0,ROW(alveo statsP2:P3548))))

I keep getting #name, or #ref, or #value errors each coming when I try to fix what I think is wrong, then I get another error.

Thanks

 

[Aladin Akyurek]

Ok I've tried the first formula, maybe my problem is my data is on another worksheet in this workbook here is what I have doesn't work but here it is

=MAX(FREQUENCY(IF(alveo statsP2:P3548>0,ROW(alveo statsP2:P3548)),IF(alveo statsP2:P3548<=0,ROW(alveo statsP2:P3548))))

I keep getting #name, or #ref, or #value errors each coming when I try to fix what I think is wrong, then I get another error.

Thanks

Replace

alveo stats

with

'alveo stats'!

in the formula.

 

[BigBubba]

Don't know where I'm going wrong, but still not working still getting #ref, #name and #value errors.
Thanks

 

[Aladin Akyurek]

Don't know where I'm going wrong, but still not working still getting #ref, #name and #value errors.
Thanks

You can't get such different errors by editing the sheet name part... Try to be exact on what error you get. That said: Control+shift+enter...

=MAX(FREQUENCY(IF('alveo stats'!P2:P3548>0,ROW('alveo stats'!P2:P3548)),IF('alveo stats'!P2:P3548<=0,ROW('alveo stats'!P2:P3548))))