Count the number of cells containing a particular word

Suppose you are asked to figure out the number of cells in a range contain a particular word, example "hi" (without double quotes).

The example is shown in the image below.


The asterik (*) is used to find matches. It substitutes any other characters.
  1. Hi* would find anything that starts with "Hi"
  2. *Hi would find anything that ends with "Hi"
  3. *Hi* would find anything that contains "Hi"
Download the workbook 
Coursera Data Science
Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

1 Response to "Count the number of cells containing a particular word"

Next → ← Prev