| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to sum multiple occurrences of a word in a table of texts
Hi,
I'm stumped on this one but I'm sure that it's doable. I have a table of data based on Towns and Dates. Let's say there are 10 Towns from B10 to B19 and Dates are from C9 to I9 The table data is text extracts from diary entries for each Date in each Town. The data may (or may not) include remarks about the weather. (Isn't this interesting!). Basically, I want to be able to count instances of the word "rain" in the data entries and display the sum of occurrences horizontally (by Town) in column A and vertically (by Date) in row 7. Thanks in advance for any advice. Zimina |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merging documents,exporting long landscape table to word with page breaks & numbers | Excel Discussion (Misc queries) | |||
| Linking table in Excel to word | Links and Linking in Excel | |||
| Multiple MS Access table sources for pivot table | Excel Discussion (Misc queries) | |||
| Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
| How to convert the table in word to excel sheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
