Functions
LARGE
k-th largest value
Try it
When to use it
When should I use LARGE instead of MAX?
MAX gives only the single highest value. LARGE returns the k-th largest, so LARGE(range, 1) equals MAX, LARGE(range, 2) is the second highest, and so on. Use it for top-N reporting.
How do I find the top three values and add them?
Sum LARGE called for each rank: LARGE(range,1) plus LARGE(range,2) plus LARGE(range,3) gives the total of the three highest values.
Use cases
Top score from a list of grades
Third-largest deal in a sales pipeline
Used in
finance · education · operations
Syntax
LARGE(array,k)Examples
=LARGE({3,5,3,5,4,4,2,4,6,7},4) // => 5