Need Help with Calc =LARGE( ) Function

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Need Help with Calc =LARGE( ) Function

Vince@Gmail
AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25  on WIN10-64 Desktop

_____________________________________

Hi:

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:

__
_POSITION_ _HIGHEST SCORES_ _Player Name_
1 233
2 222
3 194
4 188
5 185
6 179
7 176
8 174
9 184

       

       

       

       

       

       

       

       

       

       

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
Name column?


*/
/*
       
       
       
_Date_ _
_
       
/ANTHONY ?/ /BOB M./ /DENISE C./ /GLEN U./ /JASIU M./ /JOHN G./
/RAY H./ /RON J./ /SAM C./ /RUSSEL P./ /VINCE B./ /WILLIE M./ /VAN ?/
_20th February-practice #1_ _Game 1_ 92 149 122 0 117 150 61
104 197 154 184 177 n/a
_Game 2_ 0 147 148 0 130 179 97 143 212 107 185 156 n/a
_Game 3_ 0 187 152 0 129 165 80 144 181 122 141 154 n/a
_27th February-practice #2_ _Game 1_ 0 190 0 140 113 149 0 142
153 96 169 199 n/a
_Game 2_ 0 162 0 124 155 166 0 157 220 132 151 134 n/a
_Game 3_ 0 204 0 119 100 184 0 137 143 175 154 161 n/a
_6th March -Competition #1_ _Game 1_ 0 161 125 83 87 173 88 188
        222 105 179 126 119
_Game 2_ 0 168 110 146 154 185 92 159 194 167 132 157 77
_Game 3_ 0 233 113 147 108 152 129 147 176 125 173 174 0
_Competition #2_ _Game 1_ n/a n/a n/a n/a n/a n/a n/a n/a n/a
n/a n/a n/a n/a
_Game 2_ n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a
_Game 3_ n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a
_Competition #3_ _Game 1_ n/a n/a n/a n/a n/a n/a n/a n/a n/a
n/a n/a n/a n/a
_Game 2_ n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a
_Game 3_ n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a
_Competition #4_ _Game 1_ n/a n/a n/a n/a n/a n/a n/a n/a n/a
n/a n/a n/a n/a
_Game 2_ n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a
_Game 3_ n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a

       
       
       
       
       
       
       
       
       
       
       
       
       
       

        _
_ /ANTHONY ?/ /BOB M./ /DENISE C./ /GLEN U./ /JASIU M./ /JOHN G./
/RAY H./ /RON J./ /SAM C./ /RUSSEL P./ /VINCE B./ /WILLIE M./ /VAN ?/