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: