# Excel Function SMALL

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

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

## Example 1:Excel Function SMALL 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” ## Usage Notes

The SMALL function returns a numeric value based on its position in a list when sorted by value in ascending order. In other words, SMALL can return the “nth smallest” value (1st smallest value, 2nd smallest value, 3rd smallest value, etc.) from a set of numeric data.

The SMALL function takes two argumentsarray and kAn array is an array or range of numeric values.

To get nth largest values, see the LARGE function.

## Recommended Articles

### Secrets of Excel Data Visualization: Beginners to Advanced Course

Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.

This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.

So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.

Hope you learnt this Function,

1. Anshu Taneja says: