Returns the n-th highest number in a provided range
Sample Usage
大(Cost1:Cost,3)
Syntax
大(
-
range
-
n
-
range—The group of numbers to return the n-th highest value from
-
n—A number representing the position, from the highest, to return
Usage Notes
- LARGE will only look at numbers in the given range. If the range doesn’t contain numbers, you’ll receive either an #INVALID VALUE or #INVALID COLUMN VALUE error.
- If thenvalue ishigherthan the total number of values in the range, you'll receive an #INVALID DATA TYPE error.
Examples
This example references the following sheet information:
| Transaction Total | Units Sold | Price Per Unit | 销售日期 | |
|---|---|---|---|---|
| 1 | $1,170.00 | 78 | $15.00 | 02/12/19 1:55 PM |
| 2 | $1,491.00 | 42 | $35.50 | 02/15/19 10:23 AM |
| 3 | $812.00 | 217 | $200.00 | 02/20/19 2:45 PM |
Given the table above, here are some examples of using LARGE in a sheet:
| Formula | Description | Result |
|---|---|---|
| =LARGE([Transaction Total]:[Transaction Total], 1) | Returns the largest value in theTransaction Totalcolumn | $1,491.00 |
| =LARGE([Units Sold]:[Units Sold], 2) | 返回第二大value in theUnits Soldcolumn | 78 |
| =LARGE([Transaction Total]:[Price Per Unit], 5) | Returns the fifth largest value in the range from theTransaction Totalcolumn to thePrice Per Unitcolumn | $200.00 |
Still need help?
Use theFormula Handbook templateto find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.