Searching for text & counting how many times it appears
Think you meant COUNTIF.
Biff
"Dave F" wrote in message
...
=COUNTA([your range],[text you want to count, enclosed in quotation
marks])
Example: =COUNTA(A1:A10000,"this is how you count the frequency of a text
string")
Dave
--
Brevity is the soul of wit.
"smck" wrote:
I import text from various data sources. Is there a function (or if
anyone
has a macro) that will allow me to search the worksheet/workbook for a
specific text and print the number of times that text appears? The text
may
not necessarily be in the same location at all times. It could also be
combined with other text in a cell e.g. "AJAA" or "AJAA text".
As always, your help is greatly appreciated.
Thanks
|