Find repeating values across multiple datasets

Hello,

In the file below we are trying to find the list of followers that those three accounts have in common.

How can I make an automatic list appear under I3 ("Followers in common") with all the followers that those account have in common (not necessarily that we all 3 have in common, at least 2 of ofc), and then confront it with whom are those people following as shown in for the example follower.
Example is in fact a follower both of VIKTOR and NASTJA but not of TOM. Therefore is in the list but when confronted upon the three accounts it only appears as follower of VIKTOR and NASTJA

Thank you a lot,

TOM

Hi,

a very fast approach

I've copied in three columns the lists and added a service column

=IF(COUNTIF(Q:Q,Q2)>1,1,0)


A pivot to get the X

cells are formatted as "X";;


Please refer to the attachment