Using LARGE Funtion in Excel

Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score.
=LARGE(array, k)

The LARGE function syntax has the following arguments:
Array Required. The array or range of data for which you want to determine the k-th largest value.
K Required. The position (from the largest) in the array or cell range of data to return.

Note:

• If array is empty, LARGE returns the #NUM! error value.,
• If k ≤ 0 or if k is greater than the number of data points, LARGE returns the #NUM! error value.

 

 

 

 

 

For example we make a number list that contain 1 to 5 in large function find the largest value after the array or selection you must be define the largest if we type 1 the result appear the first largest data i.e., 5, if we type 2 the result is 2nd largest number i.e, 4.