# Manuals/calci/LARGE

Jump to navigation
Jump to search

**LARGE(Array,k)**

- is the array of numbers.
- is the position of the largest number.
- LARGE(), returns the k-th largest value in a data set.

## Description

- This function gives the -th largest value in the given set of numbers.
- This function can be used to find data based on relative size - such as the fourth largest number in a given list of data.
- In , is the array of data to find the -largest value. is the position from the largest to return.
- If is the number of data points in a range, then gives the largest value, and gives the smallest value.
- The function gives the result as error when

1. The array is empty. 2. or is greater than the total number of points in the given set.

## Examples

A | B | C | D | E | |
---|---|---|---|---|---|

1 | 13 | 10 | 9 | 13 | 21 |

2 | 28 | 15 | 10 | 16 | 19 |

3 | 12 | 19 | -1 | 0 | 18 |

- =LARGE(A1:E2,3) = 19
- =LARGE(A1:E2,9) = 10
- =LARGE(A2:E3,10) = -1
- =LARGE(A2:E3,9) = 0

## Related Videos

## See Also

## References