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 ?/

Reply via email to