 Formula Engine Reference Guide |
|
Back to Class Index
SMALL(R, N)
Returns the Nth smallest number in range R. Cells containing blanks or text are ignored.
Parameters
R
range of cells containing the numerical data
N
the nth position from the smallest in the range specified
Examples
A1..A9 = 1, 4, 8, 3, 7, 12, 54, 8, 23
SMALL(A1..A9, 3) = 4
SMALL(A1..A9, 1) = 1
SMALL(A1..A9, COUNT(A1..A7)) = 54