Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have over 1000 entries where one colum contains cells with multiple info
such as: Provide professional development opportunities, Subsidise the cost of training courses, Organise social events, such as presentation nights, dinners, thanks BBQs or breakfasts, Is there any simple way to count the number of times a word e.g. 'professional' appears in the 1000 cells in that column? I know how to count if there is just one word or phrase in each cell, the problem is occuring because there are multiple prhrases in each cell. Any help you could provide would be great. Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
counting the number of times value of "x" appears in a row | Excel Discussion (Misc queries) | |||
count the number of times a specific word appears in a column | Excel Worksheet Functions | |||
Counting the number of times a word appears 'anywhere' on a page | New Users to Excel | |||
Counting the number of times a specific character appears in a cell | Excel Worksheet Functions | |||
Counting the number of times a word appears in a worksheet | Excel Worksheet Functions |