# Documentation/Calc Functions/LARGE

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

LARGE

## Category:

Statistical Analysis

## Summary:

Finds the nth largest value in a list of numbers.

## Syntax:

LARGE(**Data**; **RankC**)

## Returns:

Returns a real number or an array of real numbers will be returned which is the **RankC**-th largest value in the **Data**.

## Arguments:

**Data** is the array or a reference to the range cells of data.

**RankC** is a positive integer value or an array or a reference to the cell containing that value which is the ranking of the values in the **Data**. If **RankC** is an array, the function becomes an array function.

- If
**RankC**is negative or larger than the size of**Data**then the function returns an error value. - If
**RankC**or**Data**contains non-numeric value either being passed as an array or as a reference to the cells containing that value then the function returns a #VALUE! error.

## Additional details:

None

## Examples:

Data1 | Data2 | Rank | |
---|---|---|---|

1 | 195 | 200 | 2 |

2 | 151 | 180 | 1 |

3 | 148 | 178 | 3 |

4 | 189 | 165 | 4 |

5 | 183 | 192 | 5 |

6 | 154 | 144 |

Formula | Description | Returns |
---|---|---|

=LARGE(A1:B6;2) | The function gives the second largest value in A1:B6. | 195 |

=LARGE(A1:B6;C1:C5) or =LARGE(A1:B6,{2;1;3;4;5}) it is entered as an array |
The function gives an array of the c-th largest value in A1:B6 with ranks defined in C1:C5. | 195 |

200 | ||

192 | ||

189 | ||

183 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

LARGE