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 replies

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