How to generate a STATIC unique identifier for each Excel row [Solved/Closed]
Related:
- Excel create unique id for each row
- Excel unique row id - Best answers
- Excel generate unique id - 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 rows based on cell value - Forum - Excel
- Duplicate rows based on cell value ✓ - Forum - Excel
3 replies
Blocked Profile
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
Blocked Profile
Well, right off the head, this can be accomplished with a two step method. Stay with me.
A column that holds the UNIQUE number, along with another column that keeps track of whether or not the first colum has a vlaue in it, and upon a value being placed in the first column, does not recalculate. Try to imagine:
Column A hold boolean (y/n)
Column B hold unique value.
Column C holds the actual data.
If column A is set to N (default), which in this case means "NOT LOCKED", then a unique number is generated!
Once a value is set for C, then A should be changed to Y, and no other unique number will be generated in B, unless you manually set A to "N".
Just one VERY simple way of locking the values in!
It's kind of fun to do the impossible! -Walter Elias Disney
A column that holds the UNIQUE number, along with another column that keeps track of whether or not the first colum has a vlaue in it, and upon a value being placed in the first column, does not recalculate. Try to imagine:
Column A hold boolean (y/n)
Column B hold unique value.
Column C holds the actual data.
If column A is set to N (default), which in this case means "NOT LOCKED", then a unique number is generated!
Once a value is set for C, then A should be changed to Y, and no other unique number will be generated in B, unless you manually set A to "N".
Just one VERY simple way of locking the values in!
It's kind of fun to do the impossible! -Walter Elias Disney
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover Your Yahoo Account
- How to Install a VPN
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- How to Get Free Diamonds in Free Fire
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- Computer Boots to Black Screen
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- How to Disabled Write Protection on a USB