NEWBIE QUESTION

[john cornell]

I have a list of scores (10)from golfers I want to pick the three best
scores. Each golfer has a row. After I get the three scores I can apply the
GHIN system to come up with a handicap. Is there a way to have a program
pick the three best for each golfer or do I have to do it manually?

Thanks in advance

[Niek Otten]

Look at the LARGE() function

--
Kind regards,

Niek Otten

"john cornell" <[email protected]> wrote in message
news:[email protected]...
>I have a list of scores (10)from golfers I want to pick the three best
>scores. Each golfer has a row. After I get the three scores I can apply the
>GHIN system to come up with a handicap. Is there a way to have a program
>pick the three best for each golfer or do I have to do it manually?
>
> Thanks in advance
>

[Gary Keramidas]

use the small function

or bernie helped me with this a year ago. this takes the best 3 out of the
last 5 scores. the scores for this particular person are in b9:t9

=IF(ISBLANK(E9),"",AVERAGE(SMALL(IF(OFFSET(B9:T9,0,MATCH(1E+300,B9:T9)-5,1,5)=0,MAX(B9:T9),OFFSET(B9:T9,0,MATCH(1E+300,B9:T9)-5,1,5)),{1,2,3})))

--


Gary


"john cornell" <[email protected]> wrote in message
news:[email protected]...
>I have a list of scores (10)from golfers I want to pick the three best
>scores. Each golfer has a row. After I get the three scores I can apply the
>GHIN system to come up with a handicap. Is there a way to have a program
>pick the three best for each golfer or do I have to do it manually?
>
> Thanks in advance
>

[john cornell]

the Large() did not solve the problem



*** Sent via Developersdex http://www.developersdex.com ***

[Gary Keramidas]

i have a workbook i can send if you want to see what my brother uses

--


Gary


"john cornell" <[email protected]> wrote in message
news:[email protected]...
>I have a list of scores (10)from golfers I want to pick the three best
>scores. Each golfer has a row. After I get the three scores I can apply the
>GHIN system to come up with a handicap. Is there a way to have a program
>pick the three best for each golfer or do I have to do it manually?
>
> Thanks in advance
>

[Gord Dibben]

john

=SUM(SMALL(A1:A10,{1,2,3}))

array formula so enter with CTRL + SHIFT + ENTER

returns the sum of the 3 smallest scores


Gord Dibben Excel MVP

On Sat, 26 Nov 2005 13:46:49 GMT, "john cornell" <[email protected]>
wrote:

>I have a list of scores (10)from golfers I want to pick the three best
>scores. Each golfer has a row. After I get the three scores I can apply the
>GHIN system to come up with a handicap. Is there a way to have a program
>pick the three best for each golfer or do I have to do it manually?
>
>Thanks in advance
>