Generic formula to check a list of texts in a String (use CTRL + SHIFT + ENTER)
Scenario:
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
Related Articles:
Sum if cells contain specific text
Sum if cell contains text in other cell in Excel
Count Cells that contain specific text
Split Numbers and Text from String in Excel
Highlight cells that contain specific text
Popular Articles:
50 Excel Shortcuts to Increase Your Productivity
How to use the VLOOKUP Function in Excel
How to use the COUNTIF function in Excel
How to use the SUMIF Function in Excel
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.