Back to Class Index
LARGE(R, N)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 |