Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

LARGE

Returns the Nth largest value in a dataset.

Sample Usage

LARGE(A1:B4,5)
LARGE(A1:B4,5)

Syntax

LARGE(data, rank)

  • data - The array or range containing the dataset.
  • rank - The position (from the largest) to return.

Examples

LARGE(A1:B4,5) returns the the 5th largest element from A1:B4. 

 

Notes

  • Setting rank to 5 will cause LARGE to return the 5th largest element from data.