Results 1 to 7 of 7

formula that will apply points to minimum numbers in a column and allow duplicate results

Threaded View

  1. #1
    Registered User
    Join Date
    07-12-2014
    Location
    invercargill, new zealand
    MS-Off Ver
    2007
    Posts
    26

    formula that will apply points to minimum numbers in a column and allow duplicate results

    Good Morning,

    I'm new to this forum, so hope I'm doing this correctly.

    I have a spreadsheet with golf results in one column and I want to apply points to the lowest score, second lowest, third lowest etc, however the formula I'm playing with creates an issue when there are duplicate scores, eg, if the lowest score = 100 points, second lowest = 75, third lowest 50 and all remaining scores get 25 points. formula works perfectly until there are two scores the same, eg, both receiving 100 points, then the 75 points disappear???

    formula currently looks like this:

    =IF(F3=SMALL(F:F,1),100,IF(F3=SMALL(F:F,2),75,IF(F3=SMALL(F:F,3),50,25)))

    I need to be able to have multiple results of each score, but have no idea how to achieve this.
    Last edited by hadleedog; 07-13-2014 at 11:45 PM. Reason: trying to attach file but not successful

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-12-2014, 07:14 PM
  2. Replies: 4
    Last Post: 05-20-2014, 07:11 PM
  3. [SOLVED] Formula to get the median, but ignoring the duplicate numbers in the column
    By Rianne in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-16-2013, 03:23 AM
  4. Formula/macro - Apply certain formula as per duplicate cells in column L
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2011, 12:28 AM
  5. Apply formula to a column of numbers
    By DBraun4 in forum Excel General
    Replies: 3
    Last Post: 11-05-2008, 10:21 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