Looking to add unique (sequential) number to already generated Use

[Sawtelle]

Greetings All,

I have several hundred usernames that are identical (ex. 50 "mjones"). I
want to be able to use excel if possible to place a unique and sequential
number at the end of the duplicates (after the first original of course).

I was able to create a worksheet with "Concoctonate=>Conditional
Formatting=>True&False=>Sorting"... Now just looking for a way to automate
the "adding of unique numbers" at the end of the username.... Any advice...?

Thank you!
Sawtelle

 

[Fred Smith]

If you don't need your numbers to start at 1, you can do the following:
1. Sort your column of names (assumed to be A).
2. In the next column, use the formula:
=if(a2<>a1,a2,a1&row())
3. Copy down

If you want your numbers to restart at 1:
1. Sort your column of names.
2. In column B1 enter 1
3. In b2, use:
=if(a2<>a1,1,b1+1)
4. In column C, use:
=a1&b1
5. Copy down.

If you want a consistent number of digits in the number use:
=a1&Text(b1,"00")

Once you're done, you can copy/paste special/values the results column, and
delete the originals.

Regards,
Fred