ArrayExcept

The ArrayExcept function returns an array of all unique elements from one specified array not included in another specified array. The output array is unordered.

Syntax

ArrayExcept(array1, array2)

Function arguments

array1	An array that contains elements to be included in the new array.
array2	An array that contains elements to be excluded from the new array.

Notes

• If either or both input arguments are null values, the function returns null.

• If all values in the first array are included in the second array, an empty array is returned.

Example

A table lists all available colors of different clothing items. To see all colors available for each item, excluding the colors black and white, use the ArrayExcept function:

ArrayExcept([Colors], Array("black", "white"))

ArrayExcept returns all colors listed in the [Colors] column, excluding the colors specified in the ("black", "white") array.