• 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

    Hui...

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

Using LARGE

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.
 

vletm

Excel Ninja
ComputerBeginner
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
Code:
= 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)
 
Top