Skip to main content

LARGE

Returns the k-th largest value in a data set.

CategoryStatistical
SyntaxLARGE(array, k)

Parameters

ParameterRequiredDescription
arrayRequiredThe range or array of data values.
kRequiredThe rank position from the largest (1 = largest, 2 = second largest, etc.).

Example

LARGE(A1:A10)

Auto-generated from the EngCanvas function registry.