Renaming if Duplicate with Formula

[insomned]

Hello, 

I would need a formula for IF a field in the column appears 2+ times THEN change the last character of a string in that field.

Ie, 

Name 

Tony

Tony

Mark

Isabel

Would change to

Name 

Tony

Tony_1

Mark

Isabel

Thank you! 

[IraWatt]

Hey @insomned,

Herse a simple setup to achieve that: 

The multi row groups by name and counts the number of instances. The Formula then adds on the number if its greater then 1.

Hope that makes sense,

Ira 

[Qiu]

@insomned 
I like to use the Tile tool for the grouping and sequencing situation like this case.

[binuacs]

@insomned another way of doing this with 

[grazitti_sapna]

Hello @insomned, try this workflow it is dynamic. I have tried a few cases and it works.