ComputerBeginner
New Member
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.
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.