LARGE Function

The LARGE function in Excel is a statistical function that returns the nth largest value from a range of cells. It is used to find the largest value in a list, or the second largest value, or the third largest value, and so on.

The syntax for the LARGE function is:

=LARGE(array, k)


  • array is the range of cells to be evaluated
  • k is the position of the largest value that you want to find, with 1 being the largest value, 2 being the second largest value, and so on.

For example, if you have a range of cells A1:A5 with the values 5, 8, 12, 7, and 3, the formula =LARGE(A1:A5, 2) would return 8, which is the second largest value in the range.

Download the sample files: LARGE FUNCTION – Click here