If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




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. 
Ads 
#2




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




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




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 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Column picked randomly with probability relative to number of entr  Neil Goldwasser  Excel Worksheet Functions  4  May 30th 06 08:55 AM 
Return SEARCHED Column Number of Numeric Label and Value  Sam via OfficeKB.com  Excel Worksheet Functions  23  January 30th 06 06:16 PM 
Need to Improve Code Copying/Pasting Between Workbooks  David  Excel Discussion (Misc queries)  1  January 6th 06 03:56 AM 
IF/AND/OR/DATEIF Issue...sorry...long post...  EDSTAFF  Excel Worksheet Functions  1  November 10th 05 12:28 AM 
creating a bar graph  Johnfli  Excel Discussion (Misc queries)  0  October 26th 05 08:16 PM 