Averaging Golf Scores

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.

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.