Description Computes the xth largest value in a list. If you set x at 5, LARGE will sort the values in ascending order and return the 5th largest value.
Syntax LARGE ( numbers, x)
| Argument | Description |
|---|---|
| numbers | A range reference or array constant containing between 2 and 30 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 7:
