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
|