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: [email protected]
For additional commands, e-mail: [email protected]
