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.
It comes up in this mock test: Excel test for job interviews
Your first month for $9.50 $19
50% off your first month when you join today.
Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.
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.