I’m looking for a way to array any items into column A that are both in column B and C.
Do you know any way to do this?

I have a table of functions and an table of connectors.
I want to know from my table of cables what other cables have the both the same function and connector combination.

This would be like an ARRAYUNIQUE except it would array a single instance of each duplicate between the 2 fields.