<< Click to Display Table of Contents >> LARGE (k-th largest number)

Syntax:

LARGE(Range, k)

Description:

Returns the k-th largest value in a data set. If k=1, the largest value will be returned, if k=2, the second largest value will be returned, etc.

Range is a range with numeric data – usually a reference to a cell range in which numbers are entered.

k determines which number to return.

k must not be smaller than 1 or greater than the total number of values in Range. Otherwise, the function returns a #NUM! error value.

Example:

If the cells A1:A5 are filled with the numbers 4, 2, 6, 5 and 9:

LARGE(A1:A5, 1) returns 9

LARGE(A1:A5, 2) returns 6

LARGE(A1:A5, 3) returns 5

etc.

See also:

SMALL, MAX, PERCENTILE.EXC/PERCENTILE.INC/PERCENTILE, PERCENTRANK.EXC/PERCENTRANK.INC/PERCENTRANK, RANK.EQ/RANK.AVG/RANK