View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
john cornell john cornell is offline
external usenet poster
 
Posts: 12
Default picking the best 5 out of 10

That is not really what i am looking for. I have 80 golfers and need to work
a handicap for all of them.

I think the person was from Norway. Still hoping to find the right formula

Last year some one sent a formula and i can't find it.
"JLGWhiz" wrote in message
...
Have you tried this site?
http://www.dailydoseofexcel.com/arch...golf-handicap/

"john cornell" wrote:

i wonder is there away to make it five out of 10 by changing the formula.
will try and let you know.
"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
here's a long formula i use to average the lowest 3 scores out of the
last
5 rounds. maybe it will help. it's an array formula in row 9, in this
case:

=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 need to pick the best five scores out of ten scores. I am doing this
for
a golf league. After i find a way to do this i can set up the rest of
the
formula for the handicap.

thanks in advance