Excel - To generate unique ID

Solved
wliang Posts 41 Registration date Thursday June 16, 2011 Status Member Last seen May 7, 2014 - Aug 18, 2011 at 08:38 PM
 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

3 responses

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...)
18
Genius! Thanks.
0