Posts by aijazamg

    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]