Rename Duplicate Entry

[dhukun]

Anyone can help me to solve my problem to rename duplicate entry in column, sample

house
home
house
villa
villa
house

it should be changed to
house
home
house v1
villa
villa v1
house v2

how to create function or any way to do that?

thanks in advanced.

[Don]

Are you dealing with a lot of data or just a small amount of data?

Also, why exactly do you want to do this type of naming convention? The answer to that will let us know if there might be a simpler way to achieve the desired result.

[Alkhader]

How about press CTRL+F then chose replace and write your the value that you need to replace with which you want to change it to.

I hope that what are you looking 4

Alkhader