Add a unique (sequential) number at the end of usersnames

S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a unique (sequential) number to "usuername" 5
Looking to add unique (sequential) number to already generated Use 1
Space at end of multi page list to accommodate new entries 1
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
How to assign unique number to column duplicates? 3
Count Number of Unique Cells That Don't Have Certain Characters 0
Counting unique instances of a text string 2
Numbering footnotes at end of document 1

Top