Hi all
I was previously helped with a formula that created a key in which I could reference to.
Previously the formula below would look for a “*” and then use that cell as a key.
=IFERROR(C5&INDEX(C5:C$461,MATCH("~**",C5:C$461,0)),"")
It is best shown in the attached file as its hard for me to explain.
I now need to change the formula where so it searches for a double star “**”
e.g. previously with this data:
212018 Sales in Cnt to Proc
* Total Sales
** Gross Segmental Sales
It would be key’d as:
212018 Sales in Cnt to Proc* Total Sales
But I now need this to be key'd as
212018 Sales in Cnt to Proc** Gross Segmental Sales
Can this be done?
Bookmarks