Learn How to Use Microsoft Excel SMALL Function

Microsoft Excel SMALL Function

The main purpose of the Microsoft Excel SMALL function is to get the nth smallest value. That implies, with the help of the SMALL function you can able to return the numeric values based on their position in a list ranked by the value. It can be understood as, it can retrieve "nth smallest" values like - 1st smallest value, 2nd smallest value, 3rd smallest value, and so on. So, with the help of the SMALL function, you can able to get the nth smallest value.

Return Value of SMALL Function

The return value will be the nth smallest value in the array.

Syntax of SMALL Function

=SMALL(array, n)

Where the arguments:

• array: This is the range of cells from which you want to extract the smallest values.
• n: This is the integer that specifies the position from the smallest value, i.e. the nth position.

How to Use Microsoft Excel SMALL Function?

So we know that Microsoft Excel SMALL function you can able to get the nth smallest value. That implies, with the help of the SMALL function you can able to return the numeric values based on their position in a list ranked by the value. It can be understood as, it can retrieve "nth smallest" values like - 1st smallest value, 2nd smallest value, 3rd smallest value, and so on. So, with the help of the SMALL function, you can able to get the nth smallest value.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel