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