SINGLE

Constrains an array to $1\times 1$. Returns the upper-leftmost scalar value.

Sample Usage

SINGLE(A1:C10)
SINGLE(SORT(A1:F100, 1, TRUE))

Syntax

SINGLE(array)

• array - The array to constrain.

See Also

ARRAY_CONSTRAIN