Formula to auto-assign number

[tomhelle]

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.

For example:

Original Part Qty Automatically assigned “dash numberâ€

3 -1
1 -2
0
0
2 -3

The user may change the quantities on the list therefore I need to formula
to automatically reassign the “dash number†based on the user’s input. For
example:

Revised Part Qty Automatically assigned “dash numberâ€

2 -1
0
0
7 -2

Many thanks in advance!

 

[Pete_UK]

Not another repeat posting !!

Pete

 

[Max]

You've got 2 responses in your earlier posting which went through
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---

 

[tomhelle]

Pete and Max,

Thank you both for your help and support. That worked great. My apologies
for duplicate posts. That was not my intention. The MS server had returned an
error message after my posting thus I tried several times to see if it would
go through. Didn't realize that the posts did if fact do through. Humm.

Thanks again!

 

[Pete_UK]

You're welcome, Tom.

There have been many repeat postings over the last few days as there
seems to be an error on the Microsoft Forum (which I don't use). I'm
afraid my frustration was beginning to show !!

Pete