Averaging Golf Scores

[Guest]

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.

 

[Guest]

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.

 

[Biff]

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

 

[Fred Smith]

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