Key (Formula Adjustment)

[pauldaddyadams]

Hi,

In the attached spreadsheet I have a key which will assign a unique ID based on this formula

Please Login or Register  to view this content.

The formula looks for an instance of "*" but I need this amending so it would assign the key based on at least a double star "**"

e.g. Currently Cell A4 is:
212011 Sales in Cnt to PPE* Total Sales

But I need this to be:
212011 Sales in Cnt to PPE** Gross Segmental Sales

It could be that there are instances of 3 stars or 4. If this is the case I would want it returned with the 3 or 4 stars (it doesn’t have to be exactly 2 stars but it needs to be 2 or more)

I have attached the spreadsheet

Anyone help?

[6StringJazzer]

=B4&INDEX(B4:B$37,MATCH("~*~**",B4:B$37,0))

(Not required to use code tags for formulas, only for VBA.)

[DonkeyOte]

Not required to use code tags for formulas, only for VBA

@6SJ - this is true from a Rules perspective but the board software is such that long formulae are subject to "ghost" spaces mid formula

I and a few others always post formulae within CODE tags for this reason (regardless of length).

[6StringJazzer]

@DonkeyOte: Much obliged for the tip!

[pauldaddyadams]

Thank you!! That worked, although it highlighted another problem, Doh!