Remember Me?

#1
July 18th 06, 06:42 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 2
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.

#2
July 18th 06, 06:53 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 35,218
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
#3
July 18th 06, 08:04 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 2
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

#4
July 19th 06, 01:30 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 3,572
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Neil Goldwasser Excel Worksheet Functions 4 May 30th 06 08:55 AM Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 07:16 PM David Excel Discussion (Misc queries) 1 January 6th 06 04:56 AM EDSTAFF Excel Worksheet Functions 1 November 10th 05 01:28 AM Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM

All times are GMT +1. The time now is 09:15 PM.