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.