Good morning guys...
I have been racking my (less-than-ample) brain on this one for a couple of days... please help...
If i have a questionnaire which contains something like "What countries do you do business with?" and it yields a single cell with all their answers delimited by a comma, is there a way i can check to see which/how many of those answers are on another list i have? I know that i can "text to columns" to split them but i don.t know how look through that list against another set of multiple criteria.
Essentially, a horizontal or vertical group of cells containing countries which i want to check against another high risk country list.
To illustrate....
Their answer list; UK, USA, Nigeria, Iraq, France Germany
My high risk country list; Nigeria Iraq, UAE, iran, Syria
Question; Is there a single formula to check how many of my high risk countries appear in the respondents answer list?
Huge thanks in advance!!!
I have been racking my (less-than-ample) brain on this one for a couple of days... please help...
If i have a questionnaire which contains something like "What countries do you do business with?" and it yields a single cell with all their answers delimited by a comma, is there a way i can check to see which/how many of those answers are on another list i have? I know that i can "text to columns" to split them but i don.t know how look through that list against another set of multiple criteria.
Essentially, a horizontal or vertical group of cells containing countries which i want to check against another high risk country list.
To illustrate....
Their answer list; UK, USA, Nigeria, Iraq, France Germany
My high risk country list; Nigeria Iraq, UAE, iran, Syria
Question; Is there a single formula to check how many of my high risk countries appear in the respondents answer list?
Huge thanks in advance!!!