Just to give you all a clear idea,
Column A with the following values
Apple
Amazon Inc
Alphabet
Microsoft Inc
Bank of America
Column B with the following values
Amazon.com
Apple Inc
Samsung
Alphabet
Facebook
If I compare these two columns Apple, Amazon, Alphabet are common. So I want to...