+ Reply to Thread
Results 1 to 2 of 2

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

  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.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167
    Hello hadleedog,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Replies: 4
    Last Post: 05-20-2014, 07:11 PM
  2. [SOLVED] Extract 1st and 2nd minimum numbers from a column
    By bobboy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2013, 05:25 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