How do I calculate times each word occurs in a column of cells?
<<<"If the word can occur more than once in a cell, then you'll need
something else."
Here's one "something else"<g, with word to count entered into C1:
=SUMPRODUCT(LEN(A2:A100)-LEN(SUBSTITUTE(UPPER(A2:A100),UPPER(C1),"")))/LEN(C1)
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
If the word only occurs once per cell (or 0 per cell):
=countif(a1:a100,"*yourword*")
If the word can occur more than once in a cell, then you'll need something
else.
MTSusce wrote:
Rather than use a complicated array formula, is there a simpler way to
determine how many times a particular word occurs in a range of cells in
a
column? Thank you.
--
Dave Peterson
|