+ Reply to Thread
Results 1 to 5 of 5

Help in creating an Excel spreadsheet for golf handicap calculation

  1. 07-02-2008, 06:59 AM #1
    bubuy12
    bubuy12 is offline
    Registered User
    Join Date
    07-02-2008
    Location
    Manila
    Posts
    2

    Help in creating an Excel spreadsheet for golf handicap calculation

    Hi All,

    I'm a newbie here and I would really appreciate it if you guys can help me in fixing, improving my current excel spreadsheet. My objectives are as follows:

    1) To automatically make the range of selected cells choose ONLY the lowest 10 posted out of 20 posted scores
    2) To get the average of those 10 lowest scores
    3) To multiply the average of the 10 lowest scores by .96

    The result would be the handicap index which I am looking for.
    Can you guys give me the formulas needed in achieving this?
    Thanks so much for the help!

    Cheers!
    Reply With QuoteRegister To Reply
  2. 07-02-2008, 07:12 AM #2
    arthurbr
    arthurbr is offline
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Hi and welcome to the board

    this kind of question has been posted lots of times here.
    Search the forum and you will certainly find an answer

    Cheer
    Reply With QuoteRegister To Reply
  3. 07-02-2008, 07:27 AM #3
    bubuy12
    bubuy12 is offline
    Registered User
    Join Date
    07-02-2008
    Location
    Manila
    Posts
    2
    Quote Originally Posted by arthurbr
    Hi and welcome to the board

    this kind of question has been posted lots of times here.
    Search the forum and you will certainly find an answer

    Cheer
    Thanks for the tip Arthur!
    Reply With QuoteRegister To Reply
  4. 08-23-2022, 06:22 PM #4
    redstar15
    redstar15 is offline
    Registered User
    Join Date
    01-24-2014
    Location
    Nebraska
    MS-Off Ver
    O365
    Posts
    5

    Re: Help in creating an Excel spreadsheet for golf handicap calculation

    Looking for this same calcualtion were you able to figure this out?
    Reply With QuoteRegister To Reply
  5. 08-24-2022, 12:28 AM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Help in creating an Excel spreadsheet for golf handicap calculation

    Quote Originally Posted by redstar15 View Post
    Looking for this same calcualtion were you able to figure this out?
    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    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)

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