Results 1 to 19 of 19

Amending a Key formula

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,702

    Amending a Key formula

    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?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1