LARGE Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

LARGE is an Excel Statistical function. Returns the k-th largest value in a set — e.g. the 2nd biggest sale.

LARGE syntax

=LARGE(array, k)

LARGE is used in data analysis work to summarize or test patterns across a data set.

Open the live Excel-style spreadsheet and try LARGE yourself. No Excel install or sign-up needed to start.

What does the LARGE function do in Excel?

Returns the k-th largest value in a set — e.g. the 2nd biggest sale.

What is the syntax of LARGE in Excel?

The syntax is =LARGE(array, k). array: The range or array to evaluate; k: Which ranked position to return.

Where can I practice LARGE online for free?

Open the free live spreadsheet on Cellgrids and try LARGE yourself. No Excel install is needed and you can start without signing up.