Manuals/calci/LARGE
Jump to navigation
Jump to search
LARGE(A,k)
Where A is the array or range of data for which want to decide the k-th largest value and K is the position in the array or cell range of data to return.
This function calculates the k-th largest value in a data set.
· LARGE shows the error value, when A is empty or k is less than or equal to 0 or if k is greater than the number of data points
LARGE
Lets see an example,
LARGE(A, K)
B C
3 6
8 5
5 7
7 8
8 9
=LARGE(B2:C6,4) is 8
=LARGE(B2:C6,8) is 5
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 3 | 6 | 8 | |
| Row2 | 8 | 5 | 5 | |
| Row3 | 5 | 7 | ||
| Row4 | 7 | 8 | ||
| Row5 | 8 | 9 | ||
| Row6 |
