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. |
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 |
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 |
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