New Posts For Thread: Excel help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/30325289/excel-help-pleaseHi, I have a set of football results - W, D, L - is there a formula I can use to give me streaks - eg what's the maximum wins and losses between draws?Thanks very muchWhen you say it doesn't work what do you mean? Is it giving an error? incorrect results? If it gives a #value error that mean you haven't entered it a an "array formula" by pressing and holding control and shift then pressing enter after putting thehttps://community.betfair.com/general_betting/go/thread/view/94082/30325289/excel-help-please?post_id=540907417#540907417When you say it doesn't work what do you mean? Is it giving an error? incorrect results? If it gives a #value error that mean you haven't entered it a an "array formula" by pressing and holding control and shift then pressing enter after putting theTue, 12 Aug 2014 06:15:30 -0500Thank you. I'm trying to find the longest streak without a draw. that formula doesn't seem to quite work for me, but thank you for taking the time - you've helped my understanding and I'm slowly getting there!https://community.betfair.com/general_betting/go/thread/view/94082/30325289/excel-help-please?post_id=540880351#540880351Thank you. I'm trying to find the longest streak without a draw. that formula doesn't seem to quite work for me, but thank you for taking the time - you've helped my understanding and I'm slowly getting there!Sun, 10 Aug 2014 12:28:08 -0500Just noticed the forum strips out characters as usual and missed out the not equal to part. Seems it doesn't like to show the pointy brackets. Hopefully this will show up correctly, just remove the space between the pointy bracket in the IF(A1:A100<https://community.betfair.com/general_betting/go/thread/view/94082/30325289/excel-help-please?post_id=540880031#540880031Just noticed the forum strips out characters as usual and missed out the not equal to part. Seems it doesn't like to show the pointy brackets. Hopefully this will show up correctly, just remove the space between the pointy bracket in the IF(A1:A100<Sun, 10 Aug 2014 12:06:19 -0500Are you looking for streaks between draws so wins and losses together or just separate winning/losing streaks? You can find the winning/losing streaks using the following array formula=MAX(FREQUENCY(IF(A1:A100="W",ROW(A1:A100)),IF(A1:A100"W",ROW(A1:Ahttps://community.betfair.com/general_betting/go/thread/view/94082/30325289/excel-help-please?post_id=540877115#540877115Are you looking for streaks between draws so wins and losses together or just separate winning/losing streaks? You can find the winning/losing streaks using the following array formula=MAX(FREQUENCY(IF(A1:A100="W",ROW(A1:A100)),IF(A1:A100"W",ROW(A1:ASun, 10 Aug 2014 09:12:40 -0500Hi, I have a set of football results - W, D, L - is there a formula I can use to give me streaks - eg what's the maximum wins and losses between draws?Thanks very muchhttps://community.betfair.com/general_betting/go/thread/view/94082/30325289/excel-help-please?post_id=540876501#540876501Hi, I have a set of football results - W, D, L - is there a formula I can use to give me streaks - eg what's the maximum wins and losses between draws?Thanks very muchSun, 10 Aug 2014 08:28:00 -0500