Using LARGE

[ComputerBeginner]

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]

ComputerBeginner
As a new member, Your would reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

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]

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)