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

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