In case you are interested, golf handicaps are normally the best 10 of the last
20 games -- then take 96% of this average.

--
Regards,
Fred


"Jerry" wrote in message
...
How do I write an Excel formula that will select the smallest 10 of 15 golf
scores so that I can determine the handicap for the 10? I know how to do it
with AutoFilter but I want to write a formula.

Thank you.