next up previous contents index
Next: LEFT Up: A. Function Reference Previous: ISSTRING, ISTEXT   Contents   Index


LARGE

Syntax: LARGE(R, N)

R = Range of data
N = Integer specifying Nth largest datum from R

LARGE returns the Nth largest datum in the range 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

Excel function: LARGE


next up previous contents index
Next: LEFT Up: A. Function Reference Previous: ISSTRING, ISTEXT   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003