SMALL function

Category: Statistical functions

 

What does this function do?

Returns the smallest k-th value of a data set.

Syntax:

SMALL (array,k)

• Array (required): the array or range of data for which you want to determine the k-th smallest value.
• K (required): the position (from the smallest) in the array or cell range of data to return.

Examples:

=SMALL({1,2,5,3,6}, 4)= 5

If A1:A5={1,2,5,3,6}

=SMALL({A1:A5, 4)= 5