Results 1 to 18 of 18

Calculate Win/Loss Streak & Last x games

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2008
    Location
    Canada
    MS-Off Ver
    Office 2010
    Posts
    16

    Calculate Win/Loss Streak & Last x games

    I'm trying to figure out how to calculate the Win/Loss streaks as well as the W-L-OTL results of the last x games (variable by entering number in column)

    I hope the spreadsheet will be able to show what I'm looking for as I'm unable to explain it very clearly.

    For instance, I've highlighted a team and the areas that I need some help with the formulas.
    Attached Files Attached Files
    Last edited by ziggy1971; 04-01-2017 at 05:26 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Win Loss Percentage and Last 20 Streak
    By chemmiah in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-15-2017, 06:27 AM
  2. [SOLVED] Win Loss Draw streak for last 10 games for ladder
    By steggspolak in forum Excel General
    Replies: 18
    Last Post: 05-23-2014, 06:29 AM
  3. Last X games, Max Win and Loss streak, current streak with Excel formulas
    By Biogeek1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-12-2013, 11:00 AM
  4. [SOLVED] Consecutive win/loss and current win/loss streak
    By TK2013 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-18-2013, 09:15 AM
  5. Replies: 7
    Last Post: 08-03-2013, 09:51 AM
  6. Replies: 0
    Last Post: 08-09-2012, 07:56 PM
  7. Win and loss streak
    By wongum in forum Excel General
    Replies: 2
    Last Post: 01-29-2012, 06:59 PM

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