ExcelBanter - how to pick the lowest 10 golf scores

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how to pick the lowest 10 golf scores (https://www.excelbanter.com/excel-programming/343646-how-pick-lowest-10-golf-scores.html)

David Hurwitz

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.

Deano

how to pick the lowest 10 golf scores

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.

Dick Kusleika

how to pick the lowest 10 golf scores

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.dicks-blog.com/archives/2...golf-handicap/

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

All times are GMT +1. The time now is 01:39 AM.