You can use SMALL, each time with a different index. For example, if the
data is in A1:A15
=SMALL(A1:A15,1)
....
=SMALL(A1:A15,10)

Hope this helps,
Miguel.

"Jerry" wrote:

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.