Excel - To generate unique ID Solved

Question

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

Sam · Accepted Answer

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...)

rizvisa1 · Answer

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

Game Start Now · Answer

=ROW()&COLUMN()&A2


Try This :p

Excel - To generate unique ID

3 responses

Your reply

Similar discussions

Subscribe To Our Newsletter!