Article updated on January 24, 2018

The LARGE function calculates the k-th largest value from an array of numbers.

Use the LARGE function, for example, to extract the highest number, second highest and third highest from a cell range of numbers.

Excel Function Syntax

=LARGE(array, k)


array Required. Group of numbers for which you want to calculate the k-th largest value.
k Required. The position in the group of numbers to return, sorted from the largest.


It is possible to use an array of numbers in the k argument, don't forget to enter the formula as an array formula for it to work.

Example, =LARGE(A1:A10, {1,2,3}) extracts the largest, second largest and third largest number in cell range A1:A10 at the same time.