+ Reply to Thread
Results 1 to 6 of 6

Golf spreadsheet help

  1. #1
    Registered User
    Join Date
    12-05-2013
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    8

    Golf spreadsheet help

    Hi, I found a very useful spreadsheet on your forum and have started using it for our competitions but when it sorts the scores it does not take in account that in golf, count back is used so there are no draws ie two players 36 points each,my question is can some one help me with the formula so if two or more scores are the same it then checks the last 9 scores (holes) to see who is higher if still a draw the last 6 scores(holes) if still a draw the last 3 scores(holes) then sort them in winning order , very little knowledge as you can tell with excel (2007).
    cheers

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,509

    Re: Golf spreadsheet help

    Hi
    posting a sample sheet ( no pics please) would be a great help for the members.
    I'm a newbie with PQ, so if my solution can be improved, please let me know. Thanks

  3. #3
    Registered User
    Join Date
    12-05-2013
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Golf spreadsheet help

    ooop s that would make sense
    Attached Files Attached Files

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,509

    Re: Golf spreadsheet help

    As there is VBA involved, I hope some of the VBA guys will be able to help you better than me.

  5. #5
    Registered User
    Join Date
    12-05-2013
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Golf spreadsheet help

    If I only new what VBA was thanks anyway not sure I have explained my self but i shall try in my simple way
    so the spreadsheet sorts by score (stableford) the winner has 40 points the 2nd 36 points the 3rd 36 points so the spreadsheet needs to if possible then look at the last nine holes of both players to see if there is a clear 2nd
    player 1 20 points front 9- 16 back 9
    player 2 16 points front 9- 20 back 9 player two gets 2nd cos they scored more points on the back 9 or last nine holes,but if they are still tide then it goes back 6 holes then back 3 holes.
    hope that makes it a little more clear anyway when I am finished with this spreadsheet I shall post the finished sheet so others can share.

  6. #6
    Registered User
    Join Date
    03-15-2019
    Location
    nz
    MS-Off Ver
    2016
    Posts
    1

    Re: Golf spreadsheet help

    Have you managed to find a worksheet that can do this?

+ 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. [SOLVED] Eclectic golf spreadsheet
    By Ypma in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-14-2021, 11:39 AM
  2. Spreadsheet for my golf League
    By DuncanP in forum Excel General
    Replies: 4
    Last Post: 03-30-2012, 10:39 AM
  3. Golf Spreadsheet
    By tannerbabb in forum Excel General
    Replies: 4
    Last Post: 03-31-2011, 10:03 AM
  4. Replies: 6
    Last Post: 06-06-2009, 02:47 PM
  5. golf spreadsheet
    By GOLFER in forum Excel General
    Replies: 1
    Last Post: 05-30-2005, 09:25 AM

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