Formula giving array

[Matt_88]

Hi there,

How can I get an array giving intersection between two columns?

Please see the following example.

Many thanks for cooperation.

Ciao.

A

B

C

D

E

A

B

C

Expected result >>> {A, B, C}