Returns the k-th smallest value in a data set.
Składnia
SMALL(array, k)Argumenty
arraywymagane
The array or range of numerical data for which you want to determine the k-th smallest value.
kwymagane
The position (from the smallest) in the array or range of data to return.
The SMALL function is used to identify the value at a specific rank within a range of numbers, where k represents the position from the smallest. It is useful for finding the minimum, second minimum, or any other relative rank in a dataset.
=SMALL({10, 5, 20, 8}, 2)→8Finds the 2nd smallest value in the set {10, 5, 20, 8}, which is 8.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =SMALL( and select your data range, followed by a comma and the rank k.
The function will return a #NUM! error.