| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to count occurences of word in spreadsheet formula
"Rick Rothstein \(MVP - VB\)" wrote...
That would miss something like... "Rover (my dog) is my best friend." The problem in trying to isolate words, as whole words, is being able to enumerate all of the possible delimiters for them. .... Which is why Excel formulas, unadorned VB[A] and similar languages that provide only brute force, single character at a time text parsing features are very poor tools for text processing. Regular expressions, OTOH, are made for this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Occurences | Excel Discussion (Misc queries) | |||
| Count # of Occurences | Excel Discussion (Misc queries) | |||
| count unique phrases in a word table or spreadsheet | Excel Worksheet Functions | |||
| How can you count if the same word has been used in a Spreadsheet? | Excel Discussion (Misc queries) | |||
| I would like to count # of occurences but have it be dynamic when. | Excel Worksheet Functions | |||
Threaded Mode
