Count number of text cells containing string, for each string in a table column

Hi everyone,

I would need your help on the following case. I have 2 tables:

• Table 1: contains a column with a list of countries
• Table 2: contains a column with text elements

I would like to know, for each country in table 1, the number of text elements in table 2 that contain at least one occurrence of that country.

In the example below, the desired output will be:

• Mexico: 2 occurrences (appears in 3rd and 4th items in table 2, even if it appears more than once in the 3rd item)
• Japan: 1 occurrence (1st item in table 2)
• Singapore: 1 occurrence (3rd item in table 2)
• Rwanda and Chile: 0 occurrence

Thank you in advance for your help, much appreciated!