Math & Statisticsbeginner
Find the Nth largest value with LARGE
=LARGE(B2:B100,1)
Function reference
LARGE in Excel & Google Sheets
LARGE is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.
1 beginnerBuild a custom LARGE formula →
When to use LARGE
- Find the top 3 sales figures, the second-highest temperature reading, or the fifth-largest order amount from a data column.
Worked examples (1)
Common errors with LARGE
LARGE returns
The rank argument is larger than the number of values in the range. If you ask for LARGE(B2:B10,15) but the range has only 9 values, Excel returns #NUM.
Tied values return the same result
LARGE(range,1) and LARGE(range,2) both return the same number when the top two values are tied. This is correct behaviour — use RANK to assign positions that account for ties differently.
Frequently asked questions
Is there a SMALL function for the Nth smallest value?
Yes — SMALL(range,k) returns the kth smallest value. SMALL(B2:B100,1) returns the minimum, equivalent to MIN.
Need a custom variation?
Describe your specific LARGE problem and get a formula written for your exact data.
Open generator with LARGE