+ Reply to Thread
Results 1 to 2 of 2

Negative and Positive Streaks

  1. #1
    Registered User
    Join Date
    10-15-2010
    Location
    Lexington, Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    1

    Negative and Positive Streaks

    My friends and I have a spreadsheet for a game we play and we would like to determine the streak everyone is on, including negative streaks (losing streaks). Here's how it's formatted:

    https://spreadsheets.google.com/pub?...=0&output=html


    Game | Winner
    1 David
    2 David
    3 Witten
    4 Robert
    5 Marcus
    6 Marcus

    We then have stats for each player in columns, for example:
    Name: David | Witten | Robert | Marcus
    Average: 8 9 10 7
    Streak: -4 -3 -2 +2

    We want the streak calculated automatically based on the list of winners.

    Thanks!
    Last edited by Nizerifin; 10-15-2010 at 04:59 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    07-29-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003/Excel 2010
    Posts
    534

    Re: Negative and Positive Streaks

    See small example in the attachment. You need to adapt this to your worksheet layout.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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