Excel LARGE function

Function              LARGE

Description        Excel LARGE function returns the Kth largest value (numeric) in an array.

Syntax  LARGE(array, k)

array     The array from which you want to find out the kth largest value.

k      An integer that specifies the kth position.

Example:

Here I will get the 2nd largest value from the array.