Results 1 to 3 of 3

Calculating Longest winning and losing streak.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    253

    Calculating Longest winning and losing streak.

    Hi, I'm trying to calculate my longest winning and losing streaks in a game of poker. I have the following example:

    A B C
    1 Win 1
    2 Lose 1
    3 Win 1
    4 Win 1
    5 Win 1
    6 Lose 1
    7 Lose 1

    Longest winning streak = 4
    Longest winning streak = 2

    I can't figure out how to do addition with calculation reset when results is different from previous. Has anybody done this before?

    I tried to do consecutive addition with the formula below, it always gives me a "false". Why?
    D3=IF(AND(A3="WIN",A2="WIN"),D2+1,AND(IF(A3<>A2,A2<>"Loss"),1,0))
    Last edited by Lewis Koh; 07-27-2009 at 05:47 AM. Reason: Additional formula try out

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1