+ Reply to Thread
Results 1 to 7 of 7

automatically win match for Cricket

  1. #1
    Registered User
    Join Date
    01-25-2020
    Location
    Bangladesh
    MS-Off Ver
    2007
    Posts
    33

    automatically win match for Cricket

    Hey...
    I've been working on a new table for the Cricket point table. First please download the attach file.


    A team refuse to play:

    If a team refuse to play a game then opponent will automatically win the game.
    For ex: If in sheet fixture "C20" refuse to play then I will type "WOL" in "D20" and "WOW" in "H20" instead of runs.
    Here WOW=Walkover Winner and WOL=Walkover looser.

    Now I want these changes:
    * In "C7" and "C9" will count as another match they played.
    * In "D7" and "D9" will count if I type WOW or it will remain as it is.
    * In "E7" and "E9" will count if I type WOL or it will remain as it is.


    Sorry for my poor English.
    Thanks in advance.
    Attached Files Attached Files
    Last edited by rcom; 02-07-2020 at 03:18 PM.

  2. #2
    Registered User
    Join Date
    01-25-2020
    Location
    Bangladesh
    MS-Off Ver
    2007
    Posts
    33

    Re: automatically win match for Cricket

    Anyone please!!!!!!!!!!!!!

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,093

    Re: automatically win match for Cricket

    I don't have the time to look at this in depth now since I have an appointment to go to.
    I'll look later if nobody has given you an answer.
    Just with a quick glance I would consider making an adjustment to the team names in either the points table or the fixture table so that they can be easily matched and you don't have to keep changing the formulas to include the names. Maybe just putting the unique names in a location not in the active file (like column O or maybe in column G but change the font to white so they aren't visible) then put that cell reference in the formula so you don't have to retype Dragon to MMC to Gumoti etc.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,093

    Re: automatically win match for Cricket

    rcom, could you upload (or reupload) your workbook with the current columns in your results table AND additional columns with your expected results so we know what formula to create? That would be helpful.

  5. #5
    Registered User
    Join Date
    01-25-2020
    Location
    Bangladesh
    MS-Off Ver
    2007
    Posts
    33

    Re: automatically win match for Cricket

    I have re uploaded the file. Here"s what I want:

    Scenario - 1:

    A team refuse to play:

    If a team refuse to play a game then opponent will automatically win the game.
    For ex: If in sheet "Fixture" "C20" refuse to play then I will type "WOL" in "D20" and "WOW" in "H20" instead of runs.
    Here WOW=Walkover Winner and WOL=Walkover looser.

    Now I want these changes in Sheet "Points Table":
    * In "C7" and "C9" will count as another match they played.
    * In "D7" and "D9" will count if I type WOW or it will remain as it is.
    * In "E7" and "E9" will count if I type WOL or it will remain as it is.

    Scenario - 2:

    If a match got abandoned for some reason then it will count as both team played but no result.
    For ex: If I type "NR" in sheet "Fixture" "D21" and "H21" then it will count as both team played a match and it will count as no result in sheet "Points table" "F5" and "F10".



    Sorry for my poor English.
    Thanks in advance.

  6. #6
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,093

    Re: automatically win match for Cricket

    I think I got what you want, see workbook.
    I just added a couple additional countifs to your countifs formula, added a countfis for the no results, my interpretation of what you wrote above is that W and L in columns D and E in the points table didn't need changing. Also in I4 I put in a list of the team names as they appear in your Fixture tab so you don't have to keep changing the formulas, just point to I4 and drag down. So they are not visible I color coded the font to white so they match the fill color and are not visible.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    01-25-2020
    Location
    Bangladesh
    MS-Off Ver
    2007
    Posts
    33

    Re: automatically win match for Cricket

    Quote Originally Posted by Sambo kid View Post
    I think I got what you want, see workbook.
    I just added a couple additional countifs to your countifs formula, added a countfis for the no results, my interpretation of what you wrote above is that W and L in columns D and E in the points table didn't need changing. Also in I4 I put in a list of the team names as they appear in your Fixture tab so you don't have to keep changing the formulas, just point to I4 and drag down. So they are not visible I color coded the font to white so they match the fill color and are not visible.
    I kind of formatted the formula a little bit and it worked...

    Thanks a ton.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 08-18-2019, 08:34 AM
  2. update the result of formula automatically excel 2007
    By jone kim in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-09-2018, 09:08 AM
  3. Excel 2007 : Formula for Net Run Rate for Cricket
    By nibinenator in forum Excel General
    Replies: 8
    Last Post: 04-25-2017, 12:04 PM
  4. Formula to count overs in cricket match
    By tushardnk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2015, 12:05 PM
  5. Want to cricket a Excel Based Cricket Score Sheet
    By amitmvyas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-23-2014, 12:25 PM
  6. Replies: 3
    Last Post: 12-05-2012, 03:56 AM
  7. Replies: 0
    Last Post: 09-27-2012, 02:25 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