LARGE
The LARGE function returns the nth largest value from a range of data. It can help identify top values within a dataset or array.
Syntax 🔗
=LARGE(array
, n
)
array | The range or array of data from which you want to find the nth largest value. |
n | The position (rank) of the largest value you want to return. It must be greater than or equal to 1. |
Remark | n^th^ largest isn't n^th^ value |
About LARGE 🔗
Use the LARGE function in Excel to find the nth largest value in a set of data. This function is useful for analyzing top results, like sales figures or test scores. To use it, provide the array or range of your data and specify the position of the value you need. LARGE will return the nth largest value, helping you identify key data points.
Examples 🔗
Suppose you have a dataset of exam scores in cells A1:A10 and you want to find the 3rd largest score. Use the formula: =LARGE(A1:A10, 3)
Suppose you have a range of sales revenue in cells B2:B20 and you need to determine the 5th largest revenue amount. Use the formula: =LARGE(B2:B20, 5)
Notes 🔗
Make sure the 'array' argument includes only numbers. The 'n' argument determines the position of the desired largest value and must be a positive integer. If 'n' exceeds the number of values in the array, the function returns a #NUM! error.
Questions 🔗
If the 'n' value in the LARGE function is less than 1, Excel returns a #NUM! error indicating an invalid argument.
Can the LARGE function be used with non-numeric data?No, the LARGE function is designed to work with arrays or ranges containing numerical values. If non-numeric data is present in the specified array, Excel will return a #NUM! error.
How does the LARGE function handle ties or duplicate values in the dataset?If there are ties or duplicate values in the dataset, the LARGE function will return the highest occurrence of the nth largest value. Subsequent identical values are not considered when determining the nth largest value.