Skip to Content

LARGE

Returns the k-th largest value in a data set

Syntax

LARGE(array, k)

Parameters

  • array: Required. The array or range of data
  • k: Required. The position (from the largest) in the array or cell range of data to return

Example

=LARGE(A1:A10, 3)
Returns: NumberSince: Excel 2003