Hello,
I am trying to search a large list for the number of occurrences of a word located anywhere within a string, but can't figure out how to do so with countif and find.
The list would look something like this but longer: (Searching for the number of occurrences of "apple")
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]123apple89[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]7orange[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]red_tomato[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]green_apple[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
and return 2, since apple was listed twice in this case. Any help on this topic would be greatly appreciated!
I am trying to search a large list for the number of occurrences of a word located anywhere within a string, but can't figure out how to do so with countif and find.
The list would look something like this but longer: (Searching for the number of occurrences of "apple")
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]123apple89[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]7orange[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]red_tomato[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]green_apple[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
and return 2, since apple was listed twice in this case. Any help on this topic would be greatly appreciated!