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.

Frequently Asked Questions

What is the LARGE Function?
The LARGE function is a function used in spreadsheets like Sourcetable to return the kth largest value in a data set. It selects a value based on its relative position in the data set.
What does the LARGE Function Return?
The LARGE function returns the kth largest value in a data set.
What happens if the array argument is empty?
If the array argument is empty, the LARGE function will return the #NUM! error.
How do I get the largest value from a data set?
To get the largest value from a data set, you can use the LARGE function and specify the first argument as LARGE(array,1). This will return the largest value from the data set.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.