how to pick the lowest 10 golf scores

I want the program to automatically pick the lowest 10 golf scores of the
last 20 posted.

Have you considerde the formula RANK(A1:A100) alongside the cells and then
sort by rank values?



"David Hurwitz" wrote:

> I want the program to automatically pick the lowest 10 golf scores of the
> last 20 posted.

David Hurwitz wrote:
> I want the program to automatically pick the lowest 10 golf scores of
> the last 20 posted.

David: See here

http://www.*****-blog.com/archives/2...golf-handicap/

--
**** Kusleika
MVP - Excel
Daily Dose of Excel
http://www.*****-blog.com