Home 
Search 
Today's Posts 
#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. 
#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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Column picked randomly with probability relative to number of entr  Excel Worksheet Functions  
Return SEARCHED Column Number of Numeric Label and Value  Excel Worksheet Functions  
Need to Improve Code Copying/Pasting Between Workbooks  Excel Discussion (Misc queries)  
IF/AND/OR/DATEIF Issue...sorry...long post...  Excel Worksheet Functions  
creating a bar graph  Excel Discussion (Misc queries) 