HomePrivacy PolicyFeedbackLink to usSite Map

MS Excel: Large Function

In Excel, the Large function returns the nth largest value from a set of values.

The syntax for the Large function is:

Large( array, nth_position )

array is a range or array from which you want to return the nth largest value.

nth_position is the position from the largest to return.


Applies To:

  • Excel 2007, Excel 2003, Excel XP, Excel 2000

Note:

If nth_position is larger than the number of values in array, the Large function will return the #NUM! error.

If array is empty, the Large function will return the #NUM! error.


For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Large(A1:A5, 1) would return 32
=Large(A1:A5, 2) would return 8
=Large(A1:A5, 3) would return 5.7
=Large(A1:A5, 4) would return 4
=Large(A1:A5, 5) would return -2.3
=Large({6, 23, 5, 2.3}, 2) would return 6