LARGE
Formulas / LARGEIdentify 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.
Frequently Asked Questions
What is the LARGE Function?
What does the LARGE Function Return?
What happens if the array argument is empty?
How do I get the largest value from a data set?
