You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by "Vince@GMAIL" <wa...@gmail.com> on 2018/03/09 04:41:28 UTC
Need Help with Calc =LARGE( ) Function
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 ?/