ARRAY.MASK function

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


Return array values where corresponding mask is non-zero.


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.