Forum Discussion
Suresh_Jayaraman
Jan 15, 2021Copper Contributor
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 ...
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_JayaramanJan 15, 2021Copper Contributor
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.