Description Computes the xth smallest value in a list. If you set x at 5, SMALL will sort the values in descending order and return the 5th smallest value.
Syntax SMALL ( numbers, x)
| Argument | Description |
|---|---|
| numbers | A range reference or array constant containing numbers. Text and logical values in cell references and arrays are ignored. Empty cells are ignored. |
| x | The index of the number to return after sorting the list in ascending order. X must be larger than zero and smaller than the number of values in numbers. The logical value TRUE is evaluated as 1, but FALSE will return the #NUM! error. Text will be evaluated as a number, if possible; otherwise the function will return the #VALUE! error. |
Example This function returns 4:
