LARGE Function in Excel – Return Kth Largest Value in Excel

LARGE Function in Excel returns the Kth largest value from an array of numeric values.

Syntax of LARGE Function in Excel:

LARGE( array, k )

array – An array of numeric values from which you want to find the k’th largest value.
K- The index. Value of K that is passed to find the kth largest value.

Example of LARGE Function in Excel:

Formula

First Example finds the 2^nd Largest Value
Second Example finds the 5^th Largest Value
Third Example finds the 7^th Largest Value

So the result will be

Result:

NOTE: #NUM! – Error Occurs:

If the supplied value of k is less than 1 or greater than the number of values in the supplied array
If the supplied array is empty