LARGE Function

The LARGE function is one of the statistical functions. It is used to analyze the range of cells and return the k-th largest value.

Syntax

LARGE(array, k)

The LARGE function has the following arguments:

Argument Description
array The selected range of cells you want to analyze.
k The position of the number from the largest one, a numeric value greater than 0.

Notes

How to apply the LARGE function.

Examples

The figure below displays the result returned by the LARGE function.

LARGE Function