filter

[Win]

i have two data columns
how can i get the common result ?

 

[Max]

.. i have two data columns
how can i get the common result ?

One way ..

Assuming data is in cols A & B, from row2 down

Put in C2: =IF(A2="","",ISNUMBER(MATCH(A2,B:B,0)))
Copy down till last row of data in col A
(Above compares col A against col B)

Put in D2: =IF(B2="","",ISNUMBER(MATCH(B2,A:A,0)))
Copy down till last row of data in col B
(Above compares col B against col A)

Put 2 labels into C11, and do an autofilter on cols C & D in turn

Filtering out: TRUE in each case (col C, then col D) would then
locate the matches (common items), viz.:

filtering TRUE in col C reveals items in col A found within col B
filtering TRUE in col D reveals items in col B found within col A