When using the LARGE function, the most common questions usually involve errors, unexpected results, and filling the formula across multiple cells; this section answers 3 common questions.
FAQ
What should I do if the LARGE function returns an error?
- Check whether the referenced range contains valid numeric values.
- Make sure the rank parameter
kis greater than 0 and does not exceed the number of data points. - Confirm that separators and parentheses in the formula are complete.
Why does the LARGE function return a result I did not expect?
- Check whether the referenced range is correct and does not miss or include extra cells.
- Make sure the related cells are stored as numbers instead of text.
- If duplicate values exist, review the ranking requirement again before interpreting the result.
How do I use the LARGE function in multiple cells?
- Enter the LARGE formula in the first target cell.
- Move the pointer to the fill handle at the lower-right corner of the cell.
- Drag down or across, or copy and paste the formula into other cells.
- If the data range should stay fixed, use
$to lock the cell references.
Glossary
| Term | Definition |
|---|---|
| LARGE | A spreadsheet function that returns the k-th largest value in a dataset. |
| array | The range or array argument in the LARGE function that provides the values to compare. |
| k | The rank position from largest to smallest, where 1 means the largest value. |