Excel LARGE Function

The ‘LARGE’ function in Excel will identify the nth largest value within a specified cell range.

The LARGE function can be useful in a number of circumstances. For example, you could use LARGE to calculate the 10th largest figure in a range (i.e. top 10 boundary), which could then be used to calculate the sum of all values less than or equal to that value (i.e. sum total of top 10).




  • Array – The cell range you want to look at
  • K – The nth largest value in the specified range

Function category



The LARGE function returns the nth largest value within a specified range.

Download Excel File

 Example of LARGE Formula

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.