Hi!

What if there aren't 15 scores? Are there any empty cells in the range? Are
there any zero values that you may want to exclude? Are the scores in a
column or a row?

Biff

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