Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Create Gantt Chart in Excel
  • Add Outline to Data in Excel
  • How to Create Area Chart in Excel
  • How To Insert and Customize Sparklines in Excel
  • Excel Line Chart

References

  • Extract all partial matches in Excel
  • Perform case-sensitive Lookup in Excel
  • To count total rows in a range in Excel
  • How to get last row in text data in Excel
  • How to use Excel MATCH Function

Data Validations

  • Excel Data validation with conditional list
  • Excel Data validation date in specific year
  • Data validation must not exist in list
  • Excel Data validation specific characters only
  • Excel Data validation allow weekday only

LARGE function: Description, Usage, Syntax, Examples and Explanation

by

What is LARGE function in Excel?

LARGE function is one of Statistical functions in Microsoft Excel that returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score.

Syntax of LARGE function

LARGE(array, k)

The LARGE function syntax has the following arguments:

  • Array    Required. The array or range of data for which you want to determine the k-th largest value.
  • K    Required. The position (from the largest) in the array or cell range of data to return.

LARGE function formula explanation

  • If array is empty, LARGE returns the #NUM! error value.
  • If k ≤ 0 or if k is greater than the number of data points, LARGE returns the #NUM! error value.

If n is the number of data points in a range, then LARGE(array,1) returns the largest value, and LARGE(array,n) returns the smallest value.

Example of LARGE function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Data Data
3 4
5 2
3 4
5 6
4 7
Formula Description Result
=LARGE(A2:B6,3) 3rd largest number in the numbers above 5
=LARGE(A2:B6,7) 7th largest number in the numbers above 4

Post navigation

Previous Post:

CUBEVALUE function: Description, Usage, Syntax, Examples and Explanation

Next Post:

CLEAN function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • IF function: Description, Usage, Syntax, Examples and Explanation
  • Return blank if in Excel
  • Complete List of Excel Logical Functions, References and Examples
  • IF with wildcards in Excel
  • Nested IF function example in Excel

Date Time

  • Convert text date dd/mm/yy to mm/dd/yy in Excel
  • How to determine year is a leap year in Excel
  • Get work hours between dates and times in Excel
  • Dynamic date list in Excel
  • NOW function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Group times into unequal buckets in Excel
  • Group times into 3 hour buckets in Excel
  • How to randomly assign people to groups in Excel
  • If cell contains one of many things in Excel
  • Calculate conditional mode with criteria in Excel

General

  • 231 Keyboard Shortcut Keys In Excel
  • How to create dynamic worksheet reference in Excel
  • How to set or clear a print area in Excel Worksheet
  • Convert column number to letter in Excel
  • Index and match on multiple columns in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning