How to generate a STATIC unique identifier for each Excel row
Solved/Closed
Related:
- Excel create unique id for each row
- Excel generate unique id - Best answers
- Auto generate id number in excel - Best answers
- Excel - To generate unique ID ✓ - Forum - Excel
- Formula for Unique ID's following a predefined rule - Forum - Excel
- How to create new sheets for each row in excel? ✓ - Forum - Excel
- Excel create duplicate rows based on value in a column ✓ - Forum - Excel
- Excel create rows based on cell value - Forum - Excel
3 replies
OK, here we go. Please understand, this solution will generate an error, specifically a "CIRCULAR CELL REFERENCE ERROR", but it does not change or alter the end result for locking the values.
Take a look at the image, it contains three seperate screen shots, each one after hitting F9 (recalculate). Notice the error at the bottom of the image, it was generated by the FIRST time the formula was triggered. This is a not so glam way of handling this.

Now, you could make a button to lock , and unlock the sheet, but only buttons will trigger it, as a formula cannot trigger a module!
It's kind of fun to do the impossible! -Walter Elias Disney
Take a look at the image, it contains three seperate screen shots, each one after hitting F9 (recalculate). Notice the error at the bottom of the image, it was generated by the FIRST time the formula was triggered. This is a not so glam way of handling this.
Now, you could make a button to lock , and unlock the sheet, but only buttons will trigger it, as a formula cannot trigger a module!
It's kind of fun to do the impossible! -Walter Elias Disney