AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25 on WIN10-64 Desktop
I am working with the data set shown below, at bottom.
Cells E4:T4 contain the names of 13 players. Cells E32:T43 contain the
score numerical data of interest. I used the =LARGE($E$32:$T$43;1) thru
=LARGE($E$32:$T$43;9) to calculate the nine highest scores within the
score data of interest, and obtained the following results:
I need to correlate the player's name with the HIGHEST SCORE, and fill
in the Player Name column. E.g., Position 1 shows a score of 233 (in
cell F13) and that was by player whose name is Bob M. (in cell F4).
Is there a Calc function that will "look up" the appropriate name in Row
4 for each of the remaining HIGHEST SCORES and display in the Player