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

Article with the tag:
Browse all tags