Vince, I think there might be, but it might be more useful in this situation to use Base instead of Calc
Sent from my iPhone > On Mar 7, 2017, at 6:39 PM, VinceB. <wa.two...@verizon.net> wrote: > > 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. > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org