Function 10)
Add Function FIND-X-OCCURRENCE to active workbook
= 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