# Thread: Formula for max consecutive wins and loses

1. ## Formula for max consecutive wins and loses

Hello all! I am attaching my trading journal with an overview tab and a journal tab. I am attempting to calculate the max consecutive wins and the max consecutive loses onto the overview tab from the journal tab cell L. Can anyone help me with this? Thank you!

Help Book.xlsx

2. Try these:

=MAX(FREQUENCY(IF(Journal!\$L\$2:\$L\$200="WIN",ROW(Journal!\$L\$2:\$L\$200)),IF(Journal!\$L\$2:\$L\$200<>"WIN",ROW(Journal!\$L\$2:\$L\$200))))

and

=MAX(FREQUENCY(IF(Journal!\$L\$2:\$L\$200="LOSS",ROW(Journal!\$L\$2:\$L\$200)),IF(Journal!\$L\$2:\$L\$200<>"LOSS",ROW(Journal!\$L\$2:\$L\$200))))

each has to be confirmed with CTRL+SHIFT+ENTER not just ENTER.

3. NBVC yes that worked for me! I am such a newbie at this that the \$ sign was not needed so I just figured that out to remove them and it came up great. Thank you very much!

4. Sorry about the cross posting! I didn't notice I posted that question here but at any cost I have the solution and formula needed so this posting can be closed. Thanks!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•