Excel Function : LARGE
Category
Statistical
Description
Returns the k-th largest value in a data set
Microsoft Excel Reference Page
https://support.office.com/en-us/article/LARGE-function-3af0af19-1190-42bb-bb8b-01672ec00a64
Syntax and Description of the LARGE Excel Function
The LARGE function in Excel returns the nth largest value from a data set. The syntax of the function is as follows: =LARGE(array, n) Where array is the data set and n is the position of the value to be returned.
About LARGE Excel Function
The LARGE function returns the nth largest value from a data set. The function is useful for ranking values. For example, the formula =LARGE(A1:A10,2) returns the second largest value in the range A1:A10.
