Find the runner-up with LARGE
PremiumIn E2, use LARGE to find the second-highest score in B2:B7.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Player | Points | ||||
| 2 | Ida | 88 | Second | |||
| 3 | Jon | 95 | ||||
| 4 | Kim | 79 | ||||
| 5 | Lea | 91 | ||||
| 6 | Mads | 84 | ||||
| 7 | Nora | 97 | ||||
| 8 |
Premium lesson
Unlock MIN, MAX and LARGE and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Next with premium:ROUND, ROUNDUP and ROUNDDOWNRelative and absolute references
It comes up in this mock test: Excel test for job interviews
Need help?
Why this works
LARGE(range, k) returns the k-th largest value: k = 1 is the maximum, k = 2 the runner-up. SMALL works the same way from the bottom.
Common mistake: Using MAX and then looking for the next one by eye. LARGE with 2 as the second argument finds the runner-up directly.
The answer
- E2
=LARGE(1B2:B7,22)
In plain words: Return 2the second highest of 1the points in B2:B7.