EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Statistical Functions in Excel Excel LARGE Function
 

Excel LARGE Function

Madhuri Thakur
Article byMadhuri Thakur

Updated August 23, 2023

LARGE Function in Excel

 

 

LARGE Function in Excel

A large function in excel is an inbuilt statistical function that returns the nth position or Kth position from the selected numerical array. If the Kth position is greater or larger than the values, there is an array, or if we keep the Kth position blank, it will return #Num! As error. This means while putting the Kth value in the syntax, we need to put the value which is the lowest number from the selected array or any lowest number, but it should not be in an array.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

This function can sort the information provided and find the maximum value.

LARGE Formula in Excel

Below is the LARGE Formula:

LARGE Formula in Excel

Where the passing arguments are:

  • Array–the array or range of data from which we want to select the largest value.
  • K – An integer value specifies the position from the largest value.

As the LARGE function falls under the Statistical function category, and it is a built-in function in Excel, i.e. this function can be found under the FORMULAS tab in Excel. The steps are as follows:

  • Click on the FORMULAS tab.

LARGE Step 1 LARGE Formula in Excel

  • Click on the More Functions tab.

LARGE Step 2 LARGE Formula in Excel

  • Select the Statistical functions category. It will open the drop-down list of functions.

LARGE Step 3 LARGE Formula in Excel

  • Click on the LARGE functions tab from the drop-down list. 

LARGE Step 4 LARGE Formula in Excel

  • After selecting the LARGE function, a Function arguments box will pop up.

LARGE Step 5 LARGE Formula in Excel

  • Enter the Array field with an array or range of data you want to find the nth largest value.

LARGE Step 6 LARGE Formula in Excel

  • Enter the K field; it is the position from the largest value in the array of the value to return.

LARGE Step 7 LARGE Formula in Excel

How to use the LARGE Function in Excel?

LARGE Function is very simple to use. Let us now see how to use a LARGE function with the help of some examples.

You can download this LARGE Function Excel Template here – LARGE Function Excel Template

Example #1

Suppose we have company employee data, and the company distributes incentives to their employees based on their performance. We need to find out the name of the employees who are in the top 3 on the list and received the highest incentives.

LARGE Example 1-1 LARGE Formula in Excel

To find the employee name who has achieved the largest incentive, will use the below formula:

=LARGE(C4: C13,1)

LARGE Example 1-2

The Result is:

LARGE Example 1-3

To find the employee name who has achieved the second-largest incentive, will use the below formula:

=LARGE(C4: C13,2)

LARGE Example 1-4

The Result is:

LARGE Example 1-5

To find out the employee name who has achieved the 3rd largest incentive, will use the below formula:

=LARGE(C4: C13,3)

LARGE Example 1-6

The Result is:

LARGE Example 1-7

The final results are:

LARGE Example 1-8

Example #2

Let’s consider the below example with some values.

LARGE Example 2-1

We need to arrange the above data in the order of Largest to smallest. With the help of the LARGE function, we can do this very easily.

=LARGE(A25:A31,1)

LARGE Example 2-2

The Result is:

LARGE Example 2-3

Similarly, we find other values

LARGE Example 2-4

Example #3

Let’s assume Sales data is given, and we want to see the total sales from the top 5 performers.

LARGE Example 3-1

We want to see the sales done by the top 5 sales employee:

LARGE Example 3-2

We will apply the LARGE function to select the top 5 sales performers by passing the positions from 1 to 5 as an array as a second argument (k) position and summing those values.

The formula used for solving this problem is:

=SUM (LARGE(B37:B51,{1,2,3,4,5}))

 LARGE Example 3-3

 The final result is:

 LARGE Example 3-4

Things to Remember

  • If the LARGE function returns the error value #NUM!, it means
  • The second argument value (k) is less than 1 or greater than the number of values in the given array.
  • The given array is empty.
  • Suppose the function returns the error value #VALUE! – means the second argument (k) is non-numeric.
  • The LARGE function is used to sort the data.

Recommended Article

This has been a guide to Excel LARGE Function. Here we discuss the LARGE Formula and how to use the LARGE function, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles –

  1. VLOOKUP Function in Excel
  2. LN Excel Function
  3. Excel RAND Function
  4. VALUE Formula in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download LARGE Function Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download LARGE Function Excel Template

EDUCBA

डाउनलोड LARGE Function Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW