SMALL(R, N)

 

Description

This function returns the Nth smallest number in the range R.  Cells containing blanks or text are ignored.

 

Parameters

 

R

A range of cells containing numerical data.

 

N

The Nth smallest value in the specified range.

 

Examples

 

Given:

 

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