ARRAY.MASK function

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

Description

Return array values where corresponding mask is non-zero.

Syntax

ARRAY.MASK(array, mask)

array	is an array or handle to an array.
mask	is a mask or handle to a mask to be applied to array.

If mask is smaller than array then it is applied using cyclic indices. If array has more than one row then the mask is applied to rows.