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

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

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

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

"Sawtelle" wrote in message
...
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