Z
Zimina
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
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