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

Look at the LARGE() function

--
Kind regards,

Niek Otten

"john cornell" wrote in message
...
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

the Large() did not solve the problem



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

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" wrote in message
...
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

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

--


Gary


"john cornell" wrote in message
...
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

=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"
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