Generic formula to check a list of texts in a String (use CTRL + SHIFT + ENTER)
You have a survey data in which people have answered some questions. The data entry operator entered all data as it is. See the image below.
Now you have to know who mentioned any of these 3 colors Red, Blue and Green.
Write this formula in adjacent cell and hit CTRL+SHIFT+ENTER on the keyboard.
Drag it down and you have your answers. Now how many of your audience has mentioned these three colors in there statements.
How it Works
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.