Array Transformation functions

TWOARRAY_COMPARE

Reference

» N/A

About

Checks two arrays, and returns the rows that are in one array, but not the other array.

Inputs:

- a,b: arrays
- [k]: if omitted => in a not in b, k = 1 or <> 0 => in b not in a

Code

TWOARRAY_COMPARE = LAMBDA(a, b, [k],
    LET(
        u, UNIQUE(VSTACK(a, b)),
        IFERROR(
            IF(k, UNIQUE(VSTACK(a, u), , 1), UNIQUE(VSTACK(b, u), , 1)),
            "Nothing Found"
        )
    )
)