Averaging Golf Scores

J

Jerry

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

Miguel Zapico

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

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
 
F

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Average of last 5 entries 11
Formula to add 4 lowest numbers from a column of 6 4
How to add the 10 smallest numbers out of a range of 20 numbers. 3
return multiple values when within range (greater than and less than) 11
Excel formula for golf score to handicap 1
Transfer data between two tables 3
Golf Handicap Anomoly.... 7
excel golf scores, how do I add the scores for all par 3's etc 2

Top