Hello All,

Subtitle: "Add numericals values to names within the same field to
create unique usernames"

I didn't know quite what to call this process, so its descriptive, so
please read examples carefully... here goes:

GOAL :) : I want to create unique usernames (no 2 can be the same) for
export into a MySQL database from an existing spreadsheet from first
names only (no last names avail) that are the same, see BEFORE example
below:

PROBLEM : Many records in the username column have the same or
common names but all usernames must be unique to be used in a log-in
username for member forum or blog as seen below:

BEFO
MEMBER ID[/b]_______*USERNAME*______*EMAIL ADDRESS
1_________________
2_________________
3_________________
4_________________
5_________________
6_________________
7_________________
8_________________


AFTER - METHOD#1 -here I propose to temporarily put username in
asending (alphabetical) order select the same names and somehow add a
number begining with 1 then 2,3,4..and so on to get the following
result seem below:

MEMBER ID*_______*USERNAME*______*EMAIL ADDRESS
1_________________
2_________________
3_________________
4_________________
5_________________
6_________________
7_________________
8_________________


AFTER METHOD#2: Somehow combine the username column with the member ID
column to create a unique username:

MEMBER ID*_______*USERNAME*______[b]EMAIL ADDRESS
1_________________
2_________________
3_________________
4_________________
5_________________
6_________________
7_________________
8_________________

Please explain step-by-step how to have results similar to the example
AFTER METHODS 1 or 2 or both in Excel (Mac preferred) windows O.K..

Any other ideas to skin this cat are welcome!

Thank so much in advance for your help!

Best,

-JP


--
inspireme
------------------------------------------------------------------------
inspireme's Profile: http://www.excelforum.com/member.php...o&userid=28209
View this thread: http://www.excelforum.com/showthread...hreadid=477506