Having an issue with an Array Formula sorting lists

[Pershing]

I am creating an assessment for work. As people rate their abilities, it will create a value. I am then trying to rank each value and the corresponding title. I have the values being sorted, but having an issue with my array formula sorting the corresponding title(text). Can anyone please take a look at this and help me? I was going to create a macro, but the field doesn't have access to macro enabled excel books.

[Max, Singapore]

Here's a non-array method to get the labels list auto-sorted in descending order by the ratings

In "Competency Self Assessment",
Put in R6: =N6-ROW()/10^5
Copy down to R15. This pegs onto the ratings in N6 down, the "-ROW()/10^5" is an incremental fraction term to act as tie-breaker (as there are possible ties in the ratings)


Then place in S6:
=INDEX(M$6:M$15,MATCH(LARGE($R$6:$R$15,ROWS($1:1)),$R$6:$R$15,0))
Copy down to S15 to return the sorted competency text labels. Labels with tied ratings will appear in the same relative order that they are within the source column (M6:M15)
-----------------------------------
Success? Wave it, hit the little star at the bottom left of my responses

[Pershing]

Max,

Thank you sir! That worked. Still not sure why my array wasn't working, but your way was easier anyway. :-) Nicely done!

[Max, Singapore]

welcome, glad it worked

Btw, to do an ascending auto-sort (the reverse), these would be the slight tweaks required:
In R6: =N6+ROW()/10^5
In S6: =INDEX(M$6:M$15,MATCH(SMALL($R$6:$R$15,ROWS($1:1)),$R$6:$R$15,0))