Array intersect formula

[Alla_Pob]

I have 2 tables, and I need a result that shows only inputs that are the same in both tables.
Hence, to compute the intersection of a number of arrays.

array intersect ( array1, array2 [, array#… ] )
Returns an array containing all the values of array1 that are present in all the arguments.

Where:
array1
The array with master values to check.

array2
An array to compare values against.

…
A variable list of arrays to compare.

Any workarounds at this point?

[Tom_Kerswill]

This would be a really useful feature, in addition to the ARRAY_DIFF feature request, which I think would be a real gamechanger.

[Jon_Shay]

Bumping this. This feature would be huge. Any progress on this?

[Michael_Andrew]

Upvote on this feature