LARGE(R, N)

 

Description

This function returns the Nth largest value in the range R.

 

Parameters

 

R

Range of data.

 

N

Integer specifying Nth largest value from R.

 

Examples

 

Given:

A1:A9 = 1, 4, 8, 3, 7, 12, 54, 8, 23.

 

LARGE(A1:A9, 3) = 12

 

LARGE(A1:A9, 1) = 54

 

LARGE(A1:A9, COUNT(A1:A7)) = 1