Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |