Formula Engine Reference Guide
 

 

Back to Class Index

 

LARGE(R, N)

Description
This function returns the Nth largest datum in the range R.
 
Parameters
R

Range of data
 
N
Integer specifying Nth largest datum from R
 
Examples
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