FormulaCraft

LARGE / SMALL

LARGE returns the k-th biggest value and SMALL the k-th smallest. Use them for top-N lists, second-highest, or trimming extremes.

Excel
=LARGE(B2:B100, 1)
Google Sheets
=LARGE(B2:B100, 1)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1B2:B100 is the range.
  2. 2The second argument is the rank — 1 for the largest, 2 for the second largest.
  3. 3Use SMALL the same way for the smallest values.

Need a version for your data?

Try: “Find the second highest value in column B”

Related

SUMIFSUMIFSCOUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: