Excel - To generate unique ID [Solved/Closed]

wliang 41 Posts Thursday June 16, 2011Registration date May 7, 2014 Last seen - 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 

4 replies

Best answer
Game Start Now 135 Posts Thursday January 21, 2010Registration date January 7, 2017 Last seen - 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 1677 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.
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - 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