Hey, I'm new here and would like to start off with a question. I'm really new to this, didn't know it could be so useful for me.
What I need now is a code to find duplicate words in 2 columns.
I have 2 lists of (hotel)names and I need to know how often there are similarities in these lists. So I need to know how many of the names in column A are also in column B.
Problem is that the lists are not comparable. So in list A it could say HOTEL BLABLA while list B calls it just BLABLA or Aparthotel Blabla.
I hope you know what I mean, I'm from the Netherlands so my English is not perfect. I hope you understand. Thanks in advance!
What I need now is a code to find duplicate words in 2 columns.
I have 2 lists of (hotel)names and I need to know how often there are similarities in these lists. So I need to know how many of the names in column A are also in column B.
Problem is that the lists are not comparable. So in list A it could say HOTEL BLABLA while list B calls it just BLABLA or Aparthotel Blabla.
I hope you know what I mean, I'm from the Netherlands so my English is not perfect. I hope you understand. Thanks in advance!
