Forum Discussion

Suresh_Jayaraman's avatar
Suresh_Jayaraman
Copper Contributor
Jan 15, 2021

Unique ID for a Row

Could someone help me with this requirement.

I have a requirement to create a UNIQUE ID for each row I add to a table. I have multiple tables across multiple excel files,  This ID can not be shared with any other files in any other tables.

 

Once the Row is deleted, the Unique ID is deleted along with the row I deleted and it should not be given to any other row I add in the future. 

 

I cannot think of any easy way to do this. I do not want to use VB code unless that is the only way go to forward. 

excel
Macros and VBA

2 Replies

  • Jihad Al-Jarady's avatar
    Jihad Al-Jarady
    MCT
    Jan 15, 2021
    Hi, There is a function in excel that generate random number between 0 and 1, so you would use this formula to create random and unique number. =RAND()*100000000000
    • Suresh_Jayaraman's avatar
      Suresh_Jayaraman
      Copper Contributor
      Jan 15, 2021

      Jihad Al-Jarady  Thanks for the response.

       

      I do have the requirement of UNIQUE ID and that should not change upon recalculation. Once generated and assigned, it should remain the same. Sorry I was not specific about it in the question

       

      If I am not wrong, RAND modifies the assigned values during recalculation.

      I thought about RAND initially and gave up on that approach. 

Resources