Count all cells containing a particular text [Solved]
Ask a questionchemisecure2PostsWednesday March 30, 2016Registration date
March 30, 2016
Last seen - Last answered on Mar 30, 2016 10:01PM
I am using Microsoft Office 2016, and I am trying to make an autimated numerical count of all cells which contains a certain phrase for a table. An example is "Public Health"; I want to have something similar to the following:
Simply setting an equivalence to "Public Health" will not suffice, as while some of the cells contain only the phrase, still other cells contain something similar to "Energy, Public Health". How would I go about doing this in Excel 2016?