How to use “SMALL” function in Excel

SMALL function is used to get the Smallest k-th value from the range.

SMALL Function has two required arguments i.e. array, and k

Syntax:

=SMALL(array,k)

Syntax Description:

array argument is used to give the range from which smallest value is required

k argument is used to give value for th value i.e. 1^st , 2^nd ,3^rd, 4^th … position from the array argument

Example 1: SMALL function with cell Range:

• “Column A” has number values,
• “Column B” shows the sample formula applied,
• “Column C” shows the value for k argument (position),  k-th position that is required,
• “Column D” shows the output of the function and,
• Explanation is provided in “Column E”

Hope you learnt this Function,

Don’t forget to leave your valuable comments!

If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons: