Excel LARGE Function

Use:

Computes K-th largest value in a set of data

Syntax:

LARGE( range , k )

Examples:

Cell D12 formula: LARGE( C4:G4 , 2 )

Cell D13 formula: LARGE( D3:D9 , 2 )
Cell D14 formula: LARGE( C3:G9 , 2 )

Notes:

K must be an integer between 1 and COUNT( range )

LARGE( range , 1 ) is equivalent to MAX( range )

Related Functions:

MAX, MIN, SMALL, RANK