StatisticalLevel: IntermediateAvailable in: Excel 2007+

LARGE returns the k-th largest value; SMALL returns the k-th smallest. Together they build top-N lists in any version.

Syntax

=LARGE(array, k)

Examples

Example 1

=LARGE(E2:E500, 1)

Largest sale (same as MAX).

Example 2

=LARGE(E$2:E$500, ROWS(E$2:E2))

Fill down 10 rows for a top-10 list.

Power combo

=INDEX(B:B, MATCH(LARGE(E:E, 2), E:E, 0))

Customer with the second-largest sale (ties return the first match).

Related functions

SMALL · MAX · RANK.EQ · SORT

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.