Function 09)

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