# LARGE

Formulas / LARGE
Identify the nth largest value in an array.
`=LARGE(array,k)`
• array - required argument
• k - required argument, an integer that specifies where in the array to return the largest value

## Examples

• `LARGE(A2:B6,3)`

The LARGE function returns the nth largest value from a range of numbers. For example, if you have the range A2:B6 containing the values 2, 5, 7, 11, 3, and 9, then this would return the third largest number, which is 7.

• `LARGE(A2:B6,4)`

If you want to find the 4th largest number in a range, you could use the LARGE function. For example, with the range A2:B6 containing the values 2, 5, 7, 11, 3, and 9, you would use the formula to return the fourth largest value, which is 5.

• `LARGE(A2:B6,5)`

The LARGE function can also be used to find the 5th largest number in a range. For example, if you have the range A2:B6 containing the values 2, 5, 7, 11, 3, and 9, then the formula would return the fifth largest value, which is 3.

## Summary

The LARGE function allows users to select the kth largest value from a data set. It returns the #NUM! error if the array argument is empty and the largest value if LARGE(array,1) is called.

• The LARGE function can be used to retrieve the "nth largest" value from a list, where the "nth" value is determined by its position when the list is sorted by value in ascending order.
• The LARGE function is useful for retrieving the highest scores from a test, such as the first, second, or third highest scores.