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!
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" 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.
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.
Re: Sorting from highest value to lowest and return name and not value
AliGW: Thank you very much! Worked perfectly!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks