Hi, I have a list of data and I would like to filter out those rows that have any of the following countries: "Dubai,United Arab Emirates; Seoul,South Korea; Johannesburg,South Africa; Mumbai,India; Shanghai,China"
| RowID | Countries |
| 1 | Dubai,United Arab Emirates; Seoul,South Korea; Johannesburg,South Africa; Mumbai,India; Shanghai,China |
| 2 | Abu Dhabi, United Arab Emirates; Africa; Beijing, China |
| 3 | Delhi,India; Shanghai,China; Korea, Africa |
| 4 | Korea |
Based on the following information, I would to filter out those rows that have at least any of the following countries Dubai,United Arab Emirates; Seoul,South Korea; Johannesburg,South Africa; Mumbai,India; Shanghai,China. As such I would like the filter to return row ID 1 to 4. How do I do it? Based on the above examples it should return row 1 to 4.
Also if I want the filter to return only those row IDs that have at least 50% or more match based on the countries selected how do I do it? Based on the above example it should return at least row 1 to 3.
The location columns contains a string of text like this: Dubai,United Arab Emirates; Seoul,South Korea; Johannesburg,South Africa; Mumbai,India; Shanghai,China.
