SMALL Function in Excel – Return Kth Smallest Value in Excel

SMALL Function in Excel returns the Kth Smallest value from an array of numeric values.

Syntax of SMALL Function in Excel:

• array – An array of numeric values from which you want to find the k’th smallest value.
• K- The index. Value of K that is passed to find the kth smallest value.

 

Example of SMALL Function in Excel:

Formula

• First Example finds the smallest value
• Second Example finds the 2^nd smallest value
• Third Example finds the 5^th smallest value
• Fourth Example finds the 7^th smallest value

So the result will be

Result:

NOTE: #NUM! – Error Occurs:

• If the supplied value of k is less than 1 or greater than the number of values in the supplied array
• If the supplied array is empty