formula for lowest 2 in a range


Posted by Peggy on April 04, 2001 9:08 PM

I am formatting an excel sheet to figure golf handicap index.I have all of the formulas in, but I can't figure out a formula to pull the lowest numbers in a range. For example, if I have 7 scores, I would need an average of my 2 lowest 7 differentials. I can get the lowest with the min function, Can you help me with getting more than 1 min.What formula would I use for finding the 2 lowest in (a1:a10)



Posted by Aladin Akyurek on April 04, 2001 10:08 PM

Peggy

=SMALL(A1:A10,2)

In fact the second term/argument lets you specify any smallest value of a ranges of values.

Aladin