+ Reply to Thread
Results 1 to 6 of 6

Wins and Losses last 5 games

  1. 06-09-2021, 09:13 PM #1
    showtimesaints
    showtimesaints is offline
    Registered User
    Join Date
    06-09-2021
    Location
    Toronto,canada
    MS-Off Ver
    16.72 (23040900) Microsoft Excel for Mac Licence 2019
    Posts
    57

    Wins and Losses last 5 games

    Good evening, was hoping for some help on 2 formulas. I am trying to get the total ATS(against the spread) wins and ATS losses in the last 5 games for teams.For example the Texans are 3 ATSW and 2 ATSL.
    I have a formula but don't think that it is correct because its giving wrong numbers.
    The formula I am using is, =COUNTIF(INDEX(B$2:B$256,LARGE(IF(H$2:I$257=H2,ROW(H$2:I$257)-ROW(B$2)+1),5)):H$257,B2).




    The other thing I am looking for is how to calculate current streak, wether its -1 or 1.

    As games are played I add the game results to the bottom of the sheet.



    Any help again will be so much. appreciated.

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-09-2021, 10:07 PM #2
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,459

    Re: Wins and Losses last 5 games

    Try in M2:
    Please Login or Register  to view this content.
    Copy to N2, change "W" with"L"

    In O2, is it different btw W and L?

    =M2-N2
    Attached Files Attached Files
    Quang PT
    Reply With QuoteRegister To Reply
  3. 06-09-2021, 10:26 PM #3
    showtimesaints
    showtimesaints is offline
    Registered User
    Join Date
    06-09-2021
    Location
    Toronto,canada
    MS-Off Ver
    16.72 (23040900) Microsoft Excel for Mac Licence 2019
    Posts
    57

    Re: Wins and Losses last 5 games

    This formula works! But what I did was expand out from $b$2:$b$500 to $b$2:$c$500. This calculated the teams in both away and home scenarios. Really good, thank you! Very helpful.
    Reply With QuoteRegister To Reply
  4. 06-09-2021, 10:32 PM #4
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: Wins and Losses last 5 games

    crossposted: https://www.ozgrid.com/forum/index.p...in-the-last-5/

    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Read this to understand why we ask you to do this.

    I have added the crosspost reference for you today. Please comply with this and all our rules in the future
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  5. 06-10-2021, 06:31 AM #5
    showtimesaints
    showtimesaints is offline
    Registered User
    Join Date
    06-09-2021
    Location
    Toronto,canada
    MS-Off Ver
    16.72 (23040900) Microsoft Excel for Mac Licence 2019
    Posts
    57

    Re: Wins and Losses last 5 games

    My apologies for this confusion. It was foolish of me on not knowing the rules. I will not duplicate posts moving forward.
    Reply With QuoteRegister To Reply
  6. 06-10-2021, 10:08 AM #6
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: Wins and Losses last 5 games

    It is ok to crosspost, however, it is acceptable practice among all forums that when you do crosspost, you notify all in each of them that you have and provide a link to the other location.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Rank of Wins/Losses
    By RO24 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-31-2020, 12:54 PM
  2. Counting Wins and Losses
    By chester1993 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-28-2016, 09:52 PM
  3. How to create Wins/Losses Columns
    By racefan91 in forum Excel General
    Replies: 0
    Last Post: 09-19-2013, 06:34 PM
  4. Wins and Losses columns totalling the W's and L's?
    By shivers in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-04-2013, 09:50 PM
  5. Excel 2007 : Count Consequtive Wins/Losses
    By jld5571 in forum Excel General
    Replies: 6
    Last Post: 11-15-2011, 09:40 PM
  6. Streak on Wins and Losses
    By palerider85 in forum Excel General
    Replies: 6
    Last Post: 10-24-2011, 01:05 AM
  7. Calculating Wins/Losses for teams
    By mracine923 in forum Excel General
    Replies: 3
    Last Post: 06-08-2011, 01:52 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1