LARGE

LARGE returns the k-th largest numeric value from a range, where k=1 gives the maximum. It is useful for podium rankings, top-N analysis, and dynamic highlighting without rearranging data.

Excel

=LARGE(B2:B5,2)

Google Sheets

=LARGE(B2:B5,2)

✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

Student	Score
Alice	88
Bob	95
Carol	72
Dave	90

=LARGE(B2:B5,2)→90

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

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2
Cell row 5 column 1	Cell row 5 column 2

Formula

Runs server-side · free · no signup

How it works

1Provide the data range and rank k: =LARGE(B2:B5,2).
2k=1 returns the highest value, k=2 the second-highest, and so on.
3The function returns the k-th largest numeric value from the range.

Need a version for your data?

Try: “Find the second-highest score in a test results column”

COUNTA COUNTBLANK MODE

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

Last reviewed: May 28, 2026

LARGE

Verified example

Try it with your data

How it works

Related