FWIW:
I got the same result with:

=SMALL($A$2:$A$21,ROW(1:1)) in B2 copied down to B11

without being CSE entered..


"Toppers" wrote in message
...
.....if you want sum ....

=SUM(INT(SMALL($A$1:$A$20+ROW()*0.0001,ROW(1:10))) )

Enter with Ctrl+Shift+Enter

"Toppers" wrote:

Try:

=INT(SMALL($A$1:$A$20+ROW()*0.0001,ROW(1:10)))

Enter with Ctrl+Shift+Enter and copy down for 10 rows.

HTH

"Leroy 694" wrote:

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.