LARGE function in Excel

LARGE returns the k-th largest value.

Syntax

=LARGE(array, k)

Argument	Required?	What it is
array	Required	The range or array to work on.
k	Required	The position: 1 for the largest or smallest, 2 for the second, and so on.

=MAX(B2:B6) is the top score. =LARGE(B2:B6,2) is the second-highest.

Type the formula yourself and get it graded instantly, no Excel needed.

LARGE returns the k-th largest value.

=LARGE(array, k)

Argument	Required?	What it is
array	Required	The range or array to work on.
k	Required	The position: 1 for the largest or smallest, 2 for the second, and so on.

=MAX(B2:B6) is the top score. =LARGE(B2:B6,2) is the second-highest.

Type the formula yourself and get it graded instantly, no Excel needed.