Function 10)

10) Add Function FIND-X-OCCURRENCE to active workbook

Using the function

= FindXOccurrence ( find_text , within_text , levels_deep)

You can find the starting position of the 1st, 2nd, 3rd, etc. occurrence of the find_text within the within_text.

This formula:      =FindXOccurrence ( “apple” , “Apples are great for making apple pie and apple fritters” , 2 )
Would return:      43

Notice that FindXOccurrence is case sensitive just as with Excel’s FIND function.

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc