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