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}))}  



ADVERTISEMENT
ADVERTISEMENT