How to Use the LARGE Function in Microsoft Excel

Excel Math
Excel Math teaches you how to subtract, add, divide or multiply numbers in Excel. In addition, it also helps to show you exactly how you can do it.
Entering Data in Microsoft Excel
This covers the basic instructions on how to manually enter data into the Excel spreadsheet. Moreover, you can also use this for items such as planning the layout of the spreadsheet right before entering the given data, the kinds of data which you are ought to enter, widening of columns, and learning how to edit cells in changing the data.
Spreadsheet Formatting in Microsoft Excel
Formatting is said to be part of worksheet completion. It covers the features in formatting such as

  •  Adding percent and currency symbols
  • Shading alternate data rows
  • Changing the alignment of data
  • Widening columns

Guidelines in Formatting and Creating Excel Charts
A chart or graph is known to be the visual representation of spreadsheet data. It often helps you to easily understand the given data within the worksheet since users can easily pick out the trends and patterns, which is illustrated in the chart. In Microsoft Excel, the types of graphs or charts that are most often used are a bar graph, pie chart, column chart, line graph, and Sparklines, which are available in Microsoft Excel 2019.

Working with Functions, Formulas, and Data
The functions and formulas are the two main important features in Microsoft Excel that are most often used. There are hundreds of functions and formulas, which are used to create a spreadsheet in Microsoft Excel. It is very important that beginner Excel programmers should learn how to use them as quickly as possible.
One of these functions is a LARGE Function. The LARGE function in Microsoft Excel returns the k-th largest value within the set of data. Thus, the user can use this function in selecting the value, which is based on the given relative standing. For instance, the user can absolutely use this function to return the runner-up, third-place or even the highest score. The syntax of the LARGE function is ‘LARGE(array,k)’. In this formula, the array argument is considered as the range or array of data that the user wanted to determine k-th largest value. K is considered the position within the cell range or array of data, which have to be returned.


  • If the array or range is empty, the Excel’s LARGE function returns the #NUM! error value.
  • If K values are greater than the number of data points or if K is equal to zero, the LARGE function returns the #NUM! error value.

If n is considered the number of the given data points, the LARGE function in Microsoft Excel or the ‘LARGE(array,1)’ definitely returns the largest value thus ‘LARGE(array,n)’ returns its smallest value.
Excel programmers for Business.

John Abrams a Microsoft Office expert has been working in the technology industry from the last 7 year. As a technical expert, he has written technical blogs, white papers, and reviews for many websites such as