AdvancedData Analysis
Name the second-best rep with LARGE and INDEX
Combine ranking with a lookup to return a name, not just a number.
LARGE · INDEX · MATCH
14 min40 points
LARGE
Returns the nth largest value — the third-best rep, not just the best.
Syntax
LARGE(array, k)
Statistical Functions.
A worked example
=LARGE(B2:B6,2)
Returns 118,000
The second-highest sales figure.
Where it goes wrong
It returns the value, not who achieved it. Pair it with INDEX and MATCH to get the name.
Practise LARGE
Knowing what a function does and being able to write it from memory are different skills. These close the gap.
All LARGE practice exercises →