+ Reply to Thread
Results 1 to 4 of 4

Amending a formula to change the result from highest to lowest

  1. #1
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    988

    Amending a formula to change the result from highest to lowest

    Hi, normally when I run a golf competition the result is decided by whosoever has the highest points. However, on rare occasions we play a "medal" which actually means that the lowest score wins. In the attached workbook on the "Results" worksheet I have a competition called Cambridgeshire. The result is now the wrong way round, so the highest score is 1st when I need it to be the lowest score shown in column D. I'm guessing the very first segment of the formula in Column J needs to be altered but I don't know how. Any help much appreciated.
    Attached Files Attached Files
    Last edited by Marvo; 09-19-2022 at 05:34 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,409

    Re: Amending a formula to change the result from highest to lowest

    How about this in column I copied down?

    =MATCH(SMALL($J$3:$J$67,ROWS(I$3:I3)),$J$3:$J$67,)
    Attached Files Attached Files
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    988

    Re: Amending a formula to change the result from highest to lowest

    That's will do nicely Ali. As easy as that eh? I didn't even consider Column I. Many thanks.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,409

    Re: Amending a formula to change the result from highest to lowest

    Hahaha!

    As always, you are welcome.

    Please don't forget to mark this as solved.

+ 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: 2
    Last Post: 10-15-2020, 02:18 PM
  2. [SOLVED] Formula for finding Start, Stop, Highest and Lowest value
    By mariur89 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-05-2016, 06:07 AM
  3. [SOLVED] Using Stochastic formula find highest or lowest
    By DavidRoger in forum Excel General
    Replies: 8
    Last Post: 10-21-2015, 01:32 AM
  4. How to change the lowest to highest into Highest to lowes ??
    By jasond1992 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2015, 03:38 AM
  5. [SOLVED] In need of a formula to rank highest to lowest
    By ellie2014 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2014, 12:48 AM
  6. [SOLVED] Need Formula for what time of day are sales the highest or lowest
    By rmccain in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-21-2014, 08:23 AM
  7. [SOLVED] Formula for highest/lowest cost
    By S S in forum Excel General
    Replies: 2
    Last Post: 04-29-2006, 11: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