Stack Rank with formula instead of sort...Tough one!

**drhenry1** · 07-05-2012, 08:20 PM

Hi There,

From a list of names and scores, in no particular order, I would like to stack rank the individuals 1-5 on the attached example by highest score first. Is it possible to have a formula located in the red boxes that would automatically populate the agents and scores (highest to lowest)? This is just a sample of the staff. See sample staff below! Thanks in advance for your help!

**jeffreybrown** · 07-05-2012, 08:28 PM

One Way...

F3 >> =INDEX($A$3:$A$7,MATCH(LARGE($B$3:$B$7,E3),$B$3:$B$7,0))
G3 >> =VLOOKUP(F3,$A$3:$B$7,2,0)

**drhenry1** · 07-05-2012, 08:44 PM

Thank you! That worked great!

**jeffreybrown** · 07-05-2012, 08:45 PM

You are very welcome. Glad it work for you and thanks for the feedback

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save