Advanced Excel Statistical - LARGE Function

Description

The LARGE function returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing.

LARGE (array, k)

Argument	Description	Required/ Optional
Array	The array or range of data for which you want to determine the k-th largest value.	Required
K	The position (from the largest) in the array or cell range of data to return.	Required

If n is the number of data points in a range, then −
- LARGE (array,1) returns the largest value.
- LARGE(array,n) returns the smallest value.
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.
If the specified k is non-numeric, LARGE returns the #VALUE! error value.

Excel 2007, Excel 2010, Excel 2013, Excel 2016

advanced_excel_statistical_functions.htm