Excel SMALL Function

Use:

Computes K-th smallest value in a set of data

Syntax:

SMALL( range , k )

Examples:

Cell D12 formula: SMALL( C4:G4 , 2 )

Cell D13 formula: SMALL( D3:D9 , 2 )
Cell D14 formula: SMALL( C3:G9 , 2 )

Notes:

K must be an integer between 1 and COUNT( range )

SMALL( range , 1 ) is equivalent to MIN( range )

Related Functions:

MIN, MAX, LARGE, RANK