Identifies the n

`=SMALL(array,k)`

- array - an array of numeric values
- k - an integer, representing position or rank

`=SMALL({29,14,33,19,17},1)`

The SMALL function can be used to return the smallest value in a range. For example,the example returns 14 because that is the smallest item in the list.

`=SMALL({29,14,33,19,17},2)`

The SMALL function can also be used to return the second or third smallest items in a range. For example,this returns 17 because it is the second smallest item in the list.

`=SMALL(A1:A5,1)`

You can use the SMALL function to find the minimum value in a range by setting the second argument to 1. For example, the example will return the smallest value in the range A1:A5.

The SMALL function is used for extracting the kth smallest value from a given data set.

- The SMALL function returns the smallest value at a specified position in a list, sorted by value in ascending order.
- The value of the return value is the nth smallest value in the list, regardless of whether the values in the list are sorted or not.
- SMALL ignores text values, empty cells, and TRUE or FALSE.
- SMALL throws a #NUM! error if the array has no numbers.

The SMALL function returns the kth least value in a data set.

The SMALL function returns the #NUM! error if the array argument is empty.

The SMALL function returns the #NUM! error if k is less than 0 or k is bigger than the number of data points.

The SMALL function returns the smallest value in a dataset by using SMALL(array,1).

The SMALL function returns the largest value in a dataset by using SMALL(array,n) where n is the size of the data set.

Drop CSV