Formula to auto-assign a sequential number
I have a spreadsheet that lists parts and associated quantities. The user
will be able to add and delete parts from the list. I am looking for a
formula that will automatically assign a €śdash number€ť to the parts. The dash
numbers will be in numerical order and skip any part that has a quantity of
0.
|