+ Reply to Thread
Results 1 to 5 of 5

Sorting from highest value to lowest and return name and not value

  1. #1
    Registered User
    Join Date
    07-16-2017
    Location
    norway
    MS-Off Ver
    365
    Posts
    46

    Question Sorting from highest value to lowest and return name and not value

    Hey,
    I need some help
    I have a huge data excel sheet and made a example and attached.

    What I need to do is to sort the data (data A1- D7) like in A12 to D14.
    Is there a formula i could use? To sort by highest to lowest and return the names instead of the value (A-B-C and so on)?

    Thanks for any help!
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,644

    Re: Sorting from highest value to lowest and return name and not value

    In B12 copied across and down:

    =INDEX($B$1:$D$1,MATCH(LARGE($B2:$D2,COLUMN()-1),$B2:$D2,0))
    Ali


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


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,644

    Re: Sorting from highest value to lowest and return name and not value

    Can we assume this is now resolved? If so, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  4. #4
    Registered User
    Join Date
    07-16-2017
    Location
    norway
    MS-Off Ver
    365
    Posts
    46

    Thumbs up Re: Sorting from highest value to lowest and return name and not value

    AliGW: Thank you very much! Worked perfectly!

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,644

    Re: Sorting from highest value to lowest and return name and not value

    You're welcome!

+ 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] Sorting an Array by Highest to Lowest [Excel 14, VBA Only]
    By lloydgodin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2015, 09:26 AM
  2. sorting out values from highest to lowest using VBA
    By royalB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2014, 08:22 AM
  3. Sorting by the sum of a group from highest to lowest
    By Boosh1069 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2013, 05:58 PM
  4. Sorting a column of figures into highest to lowest
    By josand in forum Excel General
    Replies: 4
    Last Post: 10-02-2012, 09:53 AM
  5. [SOLVED] Excel 2007 : Sorting column by numbers, lowest to highest
    By elryp3000 in forum Excel General
    Replies: 4
    Last Post: 06-07-2012, 11:24 AM
  6. Proper number sorting. Lowest to Highest
    By cturtle in forum Excel General
    Replies: 5
    Last Post: 08-12-2008, 11:29 AM
  7. sorting columns from lowest to highest totals
    By tvi569 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-06-2007, 08:41 PM

Tags for this Thread

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