Can someone offer assistance to me to solve a problem, using AOO
4.1.3-CALC ?
I have typically 8 or 9 players in a bowling group. We are currently
participating in a competitive tournament whereby I must submit a
5-member Team score results to the BVL Tournament administrator. Here
is what I have:
Eight players bowled three games today. I have entered each players'
name in column A, followed by their individual scores in columns C, D,
and E. I need to determine the five highest scores from the group of 8
players after each player finished 3 games of bowling.
Is their a function that would allow determination and display of the
five highest scores when considering 8x3=24 scores ?
The data looks something like this:
A B C
D E
March 7, 2017
PLAYER NAMES
GAME #1 GAME #2 GAME #3
Player#1
156 111 165
Player#2
168 211 178
Player#3
109 127 97
Player#4
148 157 136
Player#5
114 127 134
Player#6
127 166 138
Player#7
146 197 177
Player#8
167 169 121
HIGH SCORE 168 211 178
Next HIGH 1 167 197 177
Next HIGH 2 156 169 165
In the above, the HIGH SCORE for columns C, D, and E were calculated
using =MAX( ); the Next HIGH 1 and Next HIGH 2 were eyeballed !
I need to submit the five highest scores for 7 Mar 2017; and repeat this
task for the remaining 3 tournament play sessions, 14, 21, and 28 Mar 2017.
I don't know if this requires a macro or a lookup table, neither of
which I have ever used in CALC. Any help on this is appreciated very much.
Regards.
VinceB.
