Basic Functions
Advanced

Who came second? LARGE with INDEX/MATCH

LARGE finds the value; INDEX/MATCH finds whose it is.

Task:

Runner-up gets a prize too. In B9 give the name of the rep with the second-highest sales, and in B10 the name of the rep with the second-lowest.

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of LARGE, SMALL

0/3

The same formula in the other shapes it takes at work.

  1. LARGE and SMALL Functions

    Find the nth largest or smallest values.

    Core
    Intermediate
  2. A top-three list with LARGE

    Point k at a cell and fill down for 1st, 2nd and 3rd.

    Intermediate
  3. Who came second? LARGE with INDEX/MATCH

    LARGE finds the value; INDEX/MATCH finds whose it is.

    Advanced

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

10 rows × 2 columns2 cells you fill in
AB
1RepSales
2Gail41200
3Hugo55800
4Iman38900
5Jack49300
6Kira61050
7Leon44700
8
9Runner-up
10Second lowest
What this exercise teachesMay contain the answer

LARGE and SMALL return values, which are rarely what you report; you report the person. Feeding them into MATCH turns any "k-th best" into a name, and changing the 2 to a cell reference gives you a full leaderboard.