• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.


Firstly apologies for my lack of knowledge, I will try to describe my situation as best I can.

I have used LARGE to create a list of the top ten highest numbers from a table. The table consists of ten players, each player having ten numbers. What I would like to do is not only record the top ten highest numbers, but in an adjacent cell show which row (player name) the value comes from.

I hope this explains it well enough.


Excel Ninja
As a new member, Your would reread Forum Rules
especially How to get the Best Results at Chandoo.org
There are many wise points.

Have You tried to use Match-function to find players name to get that row?

Peter Bartholomew

Well-Known Member
Some 365 options. INDEX/MATCH would work with older versions of Excel
= INDEX( SORT(Data,2,-1), {1;2;3;4;5}, {1,2} )
= XLOOKUP({1;2;3;4;5}, RANK(Values, Values), Text)
= XLOOKUP( LARGE(Values, {1;2;3;4;5}), Values, Text)