Thread: How do i count the number of text Entries of one word over a range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Eaton Chris Eaton is offline
external usenet poster
  
Posts: 1
Default How do i count the number of text Entries of one word over a range
To explain here is an example of the columns i have:

THC will not Span
Nox will not Span
THC fails AVU
THC will not Span

I would like to be able to count how many times the phrase "THC" is
mentioned over the course of hundreds of data entry columns?

With this example i would look to have the answer of 3.

Please can anyone help.

Thanks
Reply With QuoteReply With Quote