Increment Alphanumeric cell values based on a range of alphanumeric cell values

  • Hi,


    I am trying to add and increment numeric value if another cell value is a particular text. Example if the cell value is NEW I am trying to get NEW1, NEW2 etc in "New Title" column. I need to apply this on around 5000 records and doesn't want to apply a macro in my template. Any easy way to do this in Excel?



    [TABLE="class: grid, width: 500, align: left"]

    [tr]


    [td]

    TItle

    [/td]


    [td]

    New Title

    [/td]


    [/tr]


    [tr]


    [td]

    MCP1

    [/td]


    [td]

    MCP1

    [/td]


    [/tr]


    [tr]


    [td]

    NEW

    [/td]


    [td]

    NEW1

    [/td]


    [/tr]


    [tr]


    [td]

    MCP2

    [/td]


    [td]

    MCP2

    [/td]


    [/tr]


    [tr]


    [td]

    ABC

    [/td]


    [td]

    ABC

    [/td]


    [/tr]


    [tr]


    [td]

    XYZ

    [/td]


    [td]

    XYZ

    [/td]


    [/tr]


    [tr]


    [td]

    NEW

    [/td]


    [td]

    NEW2

    [/td]


    [/tr]


    [tr]


    [td]

    XYZ

    [/td]


    [td]

    XYZ

    [/td]


    [/tr]


    [tr]


    [td]

    APP

    [/td]


    [td]

    APP

    [/td]


    [/tr]


    [tr]


    [td]

    NEW

    [/td]


    [td]

    NEW3

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]


    [TABLE="width: 128"]

    [tr]


    [TD="class: xl63, width: 64, align: left"][/TD]

    [/tr]


    [/TABLE]

  • Re: Increment Alphanumeric cell values based on a range of alphanumeric cell values


    Try this in B2, copied down:


    =IF(A2="NEW",A2&COUNTIF($A$2:A2,"NEW"),A2)

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • Re: Increment Alphanumeric cell values based on a range of alphanumeric cell values


    Quote from AliGW;771888

    Try this in B2, copied down:


    =IF(A2="NEW",A2&COUNTIF($A$2:A2,"NEW"),A2)



    Thanks a lot AliGW. It worked :)

  • Re: Increment Alphanumeric cell values based on a range of alphanumeric cell values


    You're welcome.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules