Excel SMALL function

Function              SMALL

Description        Excel SMALL function returns the Kth smallest value (numeric) in an array.

Syntax  SMALL(array, k)

array     The array from which you want to find out the kth smallest value.

k      An integer that specifies the kth position.

Example:

Here I will get the 2nd smallest value from the array.

Related Video Tutorials: