The LARGE function in Google Sheets is a powerful tool used to analyze numeric datasets. It allows users to identify the n-th largest value from a given set of numbers, making it particularly useful for tasks such as ranking, grading, or finding top performers in a dataset. This function can enhance data analysis and reporting by providing quick access to key metrics.
Syntax
LARGE(data, n)
- data: The range of cells or array containing the numeric values you want to analyze.
- n: The position in the sorted list of values (where 1 represents the largest value, 2 represents the second largest, and so on).
Example #1
LARGE(A1:A10, 1)
This function returns the largest value from the data range A1 to A10. Example result: if the values are 3, 7, 2, 8, 5, the output will be 8.
Example #2
LARGE(B1:B5, 3)
This example retrieves the third largest number from the values in B1 to B5. If B1:B5 contains the values 12, 15, 10, 20, and 18, the result will be 15.
Example #3
LARGE(C1:C20, 5)
This function finds the fifth largest value in the specified range C1 to C20. For instance, if the numbers are 50, 22, 35, 48, 60, the output will be 35.
Error handling
- NUM! – This error occurs if n is less than 1 or greater than the count of the numbers in data.
- VALUE! – This error indicates that the data range contains non-numeric values that cannot be compared.