| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding the number of times a word is used in a range of cells
I have a column of cells in Excel 2000 with place names in them, such as
Phoenix, Arizona; White Plains, New York; Carson City, Nevada; Dayton, Ohio; etc. Each cell usually contains two words, city and state, separated by a comma. Although sometimes it's more than two words if the city and/or state is two words, such as Carson City or New York. What function and syntax would I use to find the number of times, say, Arizona is used in the range of cells? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting the number of times a word appears | Excel Worksheet Functions | |||
| number of times consective data occurs in a range of cells | Excel Worksheet Functions | |||
| Finding Number of cells in a column of other sheet having a specific word in them | New Users to Excel | |||
| finding a number and the number of times it occurs | Excel Discussion (Misc queries) | |||
| how do I count the number of times a word is repeated in a range? | Excel Discussion (Misc queries) | |||
Threaded Mode
