@Brian: Thank you! I had not seen that function in use before. @Vince: Take a look in the Help file for another explanation of the LARGE() and SMALL() functions. Since you’re keeping track of bowling scores, you might also want to take a look at the RANK() function. From your posts, I’m thinking it may come in handy later on.
Jim Plante > On Mar 8, 2017, at 3:30 AM, Brian Barker <b.m.bar...@btinternet.com> wrote: > > At 21:39 07/03/2017 -0500, Vince Bonly 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 ... > > You'll forgive my giggling, but it always amuses me when people write an > essay on their life (but which may still not exactly specify the problem) > instead of paring their problem down to what they really need! > >> I need to determine the five highest scores from the group of 8 players >> after each player finished 3 games of bowling. Is there a function that >> would allow determination and display of the five highest scores when >> considering 8x3=24 scores ? > > So you need five results from twenty-four values - not the nine you have > shown in your example (or fifteen if we extend the idea)? > > Are your values in C3 to E10? > > For your five results, use > =LARGE(C3:E10;1) > =LARGE(C3:E10;2) > =LARGE(C3:E10;3) > =LARGE(C3:E10;4) > =LARGE(C3:E10;5) > > Even simpler (and more reliably), if you want these values in a column, start > with > =LARGE(C$3:E$10;ROW()-n) > - where "n" is a suitable value (depending on the row you choose for this top > value result) so that ROW()-n gives the result 1. Then fill this formula down > the five cells. > > Note that this technique copes with duplicate values, so if there are two > equal third highest scores, say, both will appear in your list. I'm guessing > that this is what you will want. > > I trust this helps. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
