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

1. ## 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!

2. ## 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))

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

AliGW: Thank you very much! Worked perfectly!

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

You're welcome!

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

#### 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