ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I calculate times each word occurs in a column of cells? (https://www.excelbanter.com/excel-worksheet-functions/99944-how-do-i-calculate-times-each-word-occurs-column-cells.html)

MTSusce

How do I calculate times each word occurs in a column of cells?
 
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

How do I calculate times each word occurs in a column of cells?
 
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

MTSusce

How do I calculate times each word occurs in a column of cells
 
Thanks, Dave. :^) Meg

"Dave Peterson" wrote:

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


RagDyeR

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




All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com