Page Comparison

...

excluded(arrayA, arrayB)

Returns an Array of all items that are in setA arrayA that are not in setB arrayB.

Examples

excluded(["a","b","c","d","e"],["a", "c","f","d"])

...

listToString(excluded(["a","b","c","d","e"],["a","a","c","f","d"]))

If an excluded element appears more than once in the first array (array A), then it will appear the same number of times in the array returned:

excluded(["a","b","c","d","e","e"],["a", "c","f","d"])

returns ["b","e","e"].

To be clear, if an element in the first array (array A) exists at all in the comparator array (array B), then it will not count as excluded:

excluded(["a","b","c","d","e","e"],["a", "c","f","d","e"])

returns ["b"].

Note that if you want to construct conditional expression using excluded() as a predicate, you should use an intermediary countElements() function:

...