SMALL

**Syntax:** **SMALL( R, N)**

*R* = range of cells containing the numerical data

*N* = the nth position from the smallest in the range specified

**SMALL** returns the *N*th smallest number in range *R*. Cells
containing blanks or text are ignored.

**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

**Excel function:** SMALL

Grey Trout Software

02 March 2003