Menu
EXCEL LARGE FUNCTION
Excel LARGE Function Introduction
The kth biggest value in a data collection is returned by this method. For example, if you set k as 1, the highest value from the group will be returned, and if you specify 2, the second largest value from the group will be returned.
Description of Excel LARGE Function
Syntax:
=LARGE (array, k)
Parameter list:
- array – the data collection from which you wish to get the kth highest value
- k – an integer indicating the position from the greatest value, i.e. the kth position.
Step By Step Guide of LARGE Function
In the example, we use the formula =LARGE(A2:A6,1) to calculate the biggest value from the group A2 to A6, and the largest value in the group is 900; if you want the second highest, set the second parameter to 2 and you will receive 500, and so on.
Key Points
- LARGE returns the #NUM! error value if the array is blank.
- LARGE returns the #NUM! error value if k is 0 or higher than the number of data points.
- If n represents the number of data points in a range, LARGE(array,1) returns the biggest value, whereas LARGE(array,n) returns the least.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
