Filtering / Matching

[dhakim1996]

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. 

[binuacs]

@dhakim1996 One way of doing this with the find and replace tool

[dhakim1996]

Thanks! But why does RowID4 returns a 0% when 1 country matches?

[dhakim1996]

@binuacs Thanks! But why does RowID4 returns a 0% when 1 country matches?

[BS_THE_ANALYST]

@dhakim1996 here's one way: