+ Reply to Thread
Results 1 to 3 of 3

formula for Assigning pts based on scores

  1. #1
    Registered User
    Join Date
    02-21-2017
    Location
    ohio
    MS-Off Ver
    2016
    Posts
    9

    formula for Assigning pts based on scores

    I am looking for a formula that I can use to assign points based on scores. I need to keep this to be flexible so that I can begin to assign points with a predetermined number. This is for a golf score sheet. So there might be times I need to work from 12 points down or 50 points down depending on how many people and what point system I am ranking.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: formula for Assigning pts based on scores

    Please manually add the results you expect and also some notes which explain your calculations.
    We always prefer to know the end goal so that we can test any suggestions.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    02-21-2017
    Location
    ohio
    MS-Off Ver
    2016
    Posts
    9

    Re: formula for Assigning pts based on scores

    I have attached the spreadsheet with scores for 12 golfers. In column AE I would want to assign them points (in this case 12 for the lowest score to 1 for the highest. I purposefully kept some golfers with the same score as they would have to average pts available for that range of ranking. I hope this helps.
    Attached Files Attached Files

+ 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] I need a macro to select range of scores, choose the best scores and apply a formula
    By hadleedog in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-12-2015, 03:15 PM
  2. [SOLVED] Formula to calculate supplier evaluation scores based on their profit margin %
    By The_Snook in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2015, 06:03 PM
  3. Formula to sum up scores based on letters
    By scottj15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2013, 09:12 AM
  4. Assigning positions for students scores from different sheets
    By aboyetolu in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-19-2012, 11:34 PM
  5. Replies: 3
    Last Post: 09-18-2012, 09:50 AM
  6. [SOLVED] Assigning scores to a date range
    By Koen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-20-2005, 08:05 AM
  7. [SOLVED] assigning ranks to number ranges:, what I am trying to do is turn ranges of scores
    By nikki8327 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-24-2005, 06:05 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