Excel LARGE() Function
The LARGE() function in excel returns the k-th largest value in a data set.
Syntax
LARGE (Array, kth small number from the list)
Parameter
Array (required)- This parameter represents the list of numbers from which nth largest number needs to be found out.
K(required)- This parameter represents the kth largest number which needs to be found out like 5th largest number etc.
Category
Statistical
Return
This function returns the nth largest number from the given set of values.
Example 1
Objective: Use LARGE function to find the nth largest value from the set of values
Array/List of Numbers | k-th largest number | Formula | ||
3 | 16 | 5 | 16 | =LARGE(A18:C21,D18) |
19 | 67 | 1 | 67 | =LARGE(A18:C21,D19) |
21 | 12 | -9 | 21 | =LARGE(A18:C21,D20) |
0 | -8 | 0.5 | 0.5 | =LARGE(A18:C21,D21) |
Example 2
Emp_ID | Employee Name | DOJ | Age | Department | Salary |
TC-001 | Sukla Rathore | 21-Mar-16 | 21 | Engineer | $95,000 |
TC-002 | Shivam Ghandhi | 27-Feb-16 | 39 | Sales Executive | $150,000 |
TC-003 | Thomas Mitchell | 11-Jan-16 | 40 | Engineer | $115,550 |
TC-004 | Ashish Kumar Patra | 16-Feb-16 | 19 | Engineer | $99,500 |
TC-005 | Chonmila Vualnam | 31-Mar-15 | 28 | Customer Support Executive | $35,000 |
Objective 1: Find out the age of 2rd eldest employee from the above table
Result | Formula |
39 | =LARGE(E60:E64,2) |
Objective 2: Get the sum of top 3 highest paid salaries
Result | Formula |
365050 | {=SUM(LARGE(G60:G64,{1,2,3}))} |