Add number to end of text and increase number per instance

Hi All,

Im trying to write a formula and in need of assistance!

Essentially I have a row of names in column A. What Im after is a formula (or macro) that says:-

If A1 = "Bob" then "Bob 1"
If "Bob 1" already exists then "Bob 2"

And so on......

Any help is always appreciated!

Thanks
Alex

Thats great thanks!

Is it possible to do this with a countifs so I can focus on one name?

Thanks again!

Thanks NFE,

I think I have solve it like this.......

=IF(ISNUMBER(SEARCH("bob",A3)),(A3&" "&COUNTIF($A3:$A$3,A3)),"")

Thanks for all your help
Alex