Formuladrill

Level 3: Lookups Exercise 55 of 118

Third place

An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Return the name of the rep with the third highest sales, in E2. All sales figures are different, and the answer must follow the numbers when they change.

What this exercise teaches

SORT returns a sorted copy of the table and INDEX picks one cell out of it. The older route is =INDEX(A2:A7,MATCH(LARGE(B2:B7,3),B2:B7,0)): find the third largest number, then the row it sits on.

A hint if you get stuck

SORT(A2:B7, 2, -1) sorts the table by its second column, largest first. INDEX(..., 3, 1) then takes row 3, column 1. LARGE with INDEX and MATCH also works.

Functions used: INDEX, SORT

Try it now, free, no account needed

Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Lookups