Greetings All,
I am new to the forum and hope to learn new things from everyone and also seek assistance.
Take for instance, I have an ID column that I would like Excel to auto-generate a unique ID (CR0000 and so forth) when a user enters new data. If there is no new data, leave the row as blank. How do I go about in doing so?
Thank you in advance for your assistance!
Last edited by R3d3mpt10n; 10-22-2019 at 01:27 PM. Reason: grammar
Assuming data is entered in B column.
Ex: In A2 & copy down.
=IF(B2="","","CR"&Text(Row()-1,"0000"))
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thank you CK76. How do I hide the auto ID number until a user enters new data? or is it even possible?
Hmm? If function does that.
Set B2 to which ever column that the user will update. If reference cell is blank, it will show blank. If value is entered in the cell, it will show generated ID.
However, note that since it's formula based. You can't sort the data or ID will not match the original item it was associated with.
Data entry sheet should be separated from down stream processing.
There are other alternatives, but which method to use will largely depend on your use case.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks