next up previous contents index
Next: LEFT Up: A Function Reference Previous: ISSTRING

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


next up previous contents index
Next: LEFT Up: A Function Reference Previous: ISSTRING

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999