Excel - To generate unique ID [Solved/Closed]

Posts
41
Registration date
Thursday June 16, 2011
Last seen
May 7, 2014
- Aug 18, 2011 at 08:38 PM - 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
Posts
135
Registration date
Thursday January 21, 2010
Last seen
January 7, 2017
Aug 19, 2011 at 08:36 AM
11
Thank you
=ROW()&COLUMN()&A2


Try This :p

Thank you, Game Start Now 11

Something to say? Add comment

CCM has helped 1700 users this month

9
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...)
Genius! Thanks.
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
Aug 18, 2011 at 09:51 PM
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