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