Find the runner-up with LARGE

Premium

In E2, use LARGE to find the second-highest score in B2:B7.

E2
ABCDEF
1Player Points
2Ida 88 Second
3Jon 95
4Kim 79
5Lea 91
6Mads 84
7Nora 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

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?