LARGE
Syntax:
LARGE ( array , k )
Description: Computes the kth largest value in a data set.
Arguments:
Name |
Type |
Description |
|---|---|---|
array |
array, reference |
The set of numbers from which the kth-largest value is to be determined. |
k |
number |
The position (from the largest) in the array or cell range of data to return. |
Return Type and Value: number – The kth largest value in a data set.
However, if
array is empty, the return value is unspecified.
k ≤ 0,
#NUM!is returned.k is greater than the number of data points,
#NUM!is returned.
example: