I have 95 rows of data as follows:
Mr/Ms., First Name, Middle Initial, Last name, Add1, Add2, City, State, Zip, Age. I would like to create a unique identifier ( 10 digit) for each that is not dependant on a any further calculation once established. If I choose to resort by last name, zip code, or city, the unique identifier MUST stay with the row assigned for confidential sales tracking purposes.
Can this be done?
Thank you in advance if it can.
Why a ten digit identifier if only 95 rows? Why not just number them 1-95? Simpler is often the answer.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi,
It sounds like you will be creating a new 11th column for the unique ID. In which case as long as any sort includes all 11 columns then you will have no problems.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
One way:
Row\Col Mr Bob A Smith 1234 Main St #201 Dallas TX K2: =GetCRC32(Cat(A2:J2, "|")) + 2^32 Mr Bob B Smith 1234 Main St #201 Dallas TX Mr Bob B Smith 1234 Main St #201 Dallas TX
Please Login or Register to view this content.
Last edited by shg; 10-07-2014 at 07:42 PM.
Entia non sunt multiplicanda sine necessitate
Hello Alan, The marketing company between my data and the client wants a 10 digi number similar to a claim check # for anonymity. The more randomized the number, the better, in their way of thinking.
Hello Richard, I was thinking of doing a RANDBETWEEN but it recalculates on every sort.
...Sorry, but what's the question?Originally Posted by mussonip
Nice one SHG. I'll have to dissect it to see how it works.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks, CB.
Last edited by shg; 10-07-2014 at 07:44 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks