Excel - To generate unique ID [Solved/Closed]

Posts
41
Registration date
Thursday June 16, 2011
Status
Member
Last seen
May 7, 2014
- - Latest reply:  ferg - Jan 1, 2015 at 02:13 PM
Hello,
Good day. I would like to generate a unique ID from date and a customer number field. I tried this way but it was not working as desired. Below is how I started off.

Customer number in A2 is 12345
=today()&$A2

The result seems to be okay when I saved the file. However, when I opened the file again the next day, the ID was different as it used the date of the day I open the file to generate the unique ID.

How should I work around this? Appreciate the advice.

Thank you in advance for the help.

Best regards,
wliang
See more 

3 replies

Best answer
approved by Jean-François Pillou on Nov 30, 2018
16
Thank you
Another very easy way to generate unique numeric identifiers:
  • 1. In A2, enter a random number (1000)
  • 2. In A3, enter the formula: =A2+1
  • 3. Copy A3
  • 4. Double click the right lower corner of the cell


This will populate the column, adding 1 to each successive cell (1000, 1001, 1002...)

Say "Thank you" 16

A few words of thanks would be greatly appreciated. Add comment

CCM 5866 users have said thank you to us this month

Genius! Thanks.
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
6
13
Thank you
=ROW()&COLUMN()&A2


Try This :p
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
754
5
Thank you
formula will not work like this. As the formula would be calculated each time

Your requirement is not clear to me. I am assuming that you would be entering customer id in cell A2, and in B2 you would like to see some thing like what you tried. So either you use the formula and then use copy - paste special as values manually or do the same by a macro

Since the macro would depend on your usage of the book like id can change, id remains same, id can repeat on row etc, it is hard to give you any concrete answer