Most Serial Number generation formulas create a serial number that will not follow sorts created in other columns Typically row based formulas will not follow sorted items and fill based will not continue to fill in a table with new entries.
Anybody have any solutions?
@kayfesoutlook-com
Indeed, serial numbers based on row number or something like "number above +1" will not hold when you sort the table or insert rows. What kind of sequence do you need?
@kayfesoutlook-com
Indeed, serial numbers based on row number or something like "number above +1" will not hold when you sort the table or insert rows. What kind of sequence do you need?
Just a 1 and 1+ every entry thereafter. Once the entry is made it needs to stay and follow the log details - pretty simple really.
You could copy and Paste Values after entry. That does seem like a bit of work in my mind, but it will preserve the value if you then do any sorting.
As @alansidman suggested, just keep values. But you don't need a formula firsthand then copy/paste values. Just enter 1 at the top, 2 directly below it and then double click on the 'fill handle' of the 2nd cell and Excel will copy the sequence all the way down. I do that all the time when working with datasets where I want to preserve the original order of data entry. There is no other way unless you want to do it via VBA. But that's not something I can help with.
No other way - got it - thank you.