ARRAY.GRADE function

This article describes the formula syntax of the ARRAY.GRADE function.

Description

Grade _count elements of array in increasing (_count >= 0) or decreasing (n < 0) order.

Syntax

ARRAY.GRADE(array, _count)

array	is an array or handle to an array to grade
_count	is an optional number of elements to partial grade. Default is 0.

Grade all elements of array in increasing numerical order when _count = 0. If_count = -1 grade in decreasing order. If _count > 0 only grade the smallest _count values. If _count < -1 only grade the largest -_count values.

Note ARRAY.INDEX(array, ARRAY.GRADE(array)) is the same as ARRAY.SORT(array)

array must not be a handle.