Function 09)
Add Function FINDCOUNT to active workbook
Using the function: =FindCount( find_text , within_text)
You can find out how many times the find_text appears within the within_text.
=FindCount(“apple”,”Apples are great for making apple pie and apple fritters”) Would return: 2
Notice that FindCount is case sensitive just like Excel’s FIND function.
TIP: Use a Case statement to ignore case:
=FindCount(“APPLE”,UPPER(“Apples are great for making apple pie and apple fritters”))
Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc