SMALL Function Explained
The SMALL function in Microsoft Excel returns the nth smallest value from a range of values. It takes two arguments: an array of values and a number n that specifies which smallest value to return. The SMALL function is useful for finding the smallest values in a range of data.
SMALL Function Syntax
SMALL(array, k)
- array: The range of cells to consider when looking for the kth smallest value.
- k: The position (from the smallest) in the array or range of cells to return the value of.