You need to provide some details:

Will there *always* be 20 scores?
If there aren't 20 scores what do you want to do?
Where are these scores? Do they go down a column or across a row?
Are there any empty cells in your range of scores?

--
Biff
Microsoft Excel MVP


"Leroy 694" <Leroy wrote in message
...
of 20.
I am trying to create a formula/macro for calculating my golf handicap in
Excel. I need a formula that will select the lowest 10 scores of the
latest
20 posted.