Lesson 31 · Math & Ranking
LARGE & SMALL
Find the 2nd, 3rd or nth highest and lowest values with LARGE and SMALL in Google Sheets.
What is the second-highest score? Answer in D2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
The nth highest or lowest value
=LARGE(data, n)
=SMALL(data, n)
LARGE(data, 1) is the same as MAX, and LARGE(data, 2) is the runner-up. SMALL works the same way from the bottom.
Ties count separately: if the two top scores are both 38, then LARGE(..., 2) is also 38.
Build a top-3 list with =LARGE($B$2:$B$11, 1), 2, 3, then use INDEX MATCH to pull the names.