[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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. |
|
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:
LARGE({3,5,3,5,4;4,2,4,6,7},3) results in 5
LARGE({3,5,3,5,4;4,2,4,6,7},7) results in 4
end example]