Assigning Unique ID

[ClikClak]

Hi All-

I have a 13k row spreadsheet that I need to assign a unique ID to each client to import into a database. There are many repeat clients in the spreadsheet that need to have the same ID. The only fields in the spreadsheet are first name, last name, address1, address2, city, state, zip, phone#, fax#. Does anyone know a way that I assign a unique ID to the client based on the fields I have available to identify each unique client.

Thanks in advance

ClikClak

[NBVC]

If you can sort list so that all like items are together, then assuming you are only interested in Last Name and First Names for uniquess..

And Assuming your data is columns A to F

Then in G2...

=IF(A2&B2=A1&B1,G1,G1+1)

copied down

you can add more to the concatenations if more columns are needed to determine uniqueness..but the like rows are to be grouped together.

Also if you need to put letters in front or behind each code, then just concatenate to the formula

e.g. ="CUS"&IF(A2&B2=A1&B1,G1,G1+1)

or

=TEXT(IF(A2&B2=A1&B1,G1,G1+1),"0000") if you need to product 4 digits codes,

[ClikClak]

That worked perfectly

Thanks so much. I'm glad I stopped doing it manually at 50 and asked the question.

Thanks again,

ClikClak