How do I use LARGE in Excel?
Use LARGE when you want to return a top-ranked value. Enter Target range, Rank in that order, then add optional arguments when needed.
Excel Function
LARGE
Returns the k-th largest value in an array.
LARGE(array, k)Arguments
array
RequiredSpecify a reference range. You can drag or click start/end cells.
k
RequiredEnter a numeric value.
Practice Preview
Use LARGE to return the 2th largest value in Sales in column D.
Example Table
| # | AProduct ID | BProduct Name | CCategory | DSales |
|---|---|---|---|---|
| 2 | P001 | Apple | Food | 1200 |
| 3 | P002 | Banana | Food | 980 |
| 4 | P003 | Notebook | Stationery | 450 |
| 5 | P004 | Pen | Stationery | 300 |
| 6 | P005 | Grapes | Food | 1500 |
| 7 | P006 | Ruler | Stationery | 250 |
| 8 | P007 | Peach | Food | 860 |
How to Use (Formula)
=LARGE(D2:D8, 2)Result
1200
Practice This Function
LARGE FAQ
Where can I practice LARGE?
Use the "Start Function Practice" button to jump straight into LARGE drills.
What arguments does LARGE use?
The main arguments are Target range, Rank. Enter them in order.