LARGE(k, list)

The LARGE function calculates the k-th largest number in a list of numbers. k should be greater than 0 and not greater than the number of numbers in the list.

For example,

LARGE(3, 9, 234, 4, 56, 888)

returns 56, the third largest number.

See also:

Other statistical functions