Results 1 to 27 of 27

Tennis scoring macro

Threaded View

  1. #18
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Tennis scoring macro

    The sheet called "Logscores" is exactly what i want, however. I want to create some formulas based on the values in here yet if i start new game it will no longer work and the formulas disappear.
    Essentially what i want is to have the scores in running so something like this:
    If games = 1, then my formula will return the values in those two colums: CumPoints-A & CumPoints-B.
    This would continue as the game continues, so i would have a list of Game 1, Game 2 etc etc and the points scored in each. I would like these formulas not to need changed so when i do clear results and start a new game they remain.

    Any ideas?
    Cheers.

    1.Test the attached to see if your formulas remain intact.

    2. After more than one game, I am not sure what you want. Do you want:
    - value on each row to say GAME 01, 02, 03... up to end of match
    - value on each row to say SET 1, GAME 01 ... to end of set1, SET2 GAME01 ... to end of set2

    3. Would it help to have a worksheet summarising points by game?
    or do you prefer everything in the same worksheet?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] tennis game
    By BeddisC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2016, 07:56 AM
  2. Simulating a tennis game
    By PaulStoryBro in forum Excel General
    Replies: 5
    Last Post: 03-19-2014, 12:18 AM
  3. [SOLVED] Scoring responses by macro
    By spiwere in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-19-2013, 10:01 AM
  4. Tennis Ranking
    By clundeen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2011, 10:47 AM
  5. Scoring Macro
    By jkarthi22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2008, 05:33 AM
  6. Tennis set combinations
    By Raigmore in forum Excel General
    Replies: 15
    Last Post: 01-04-2006, 10:15 AM
  7. [SOLVED] I need a template for scoring tennis matches
    By Jack in forum Excel General
    Replies: 0
    Last Post: 10-06-2005, 08:05 PM

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