Is there a formula to return the position of the next keyword if there are multiple keywords? For example if I have "Gross Return Gross Return" in cell A1, is there a formula to get the position of the second Gross in excel?
For example if I use =search("Gross",A1)
, the result would be 1. But I want the result to be 14.
you can use the following formula:
=FIND("gross",A1,FIND("gross",A1)+2)
hope it works for you.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments