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: