Skip to main content

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:

ArgumentDescription
arrayThe selected range of cells you want to analyze.
kThe 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