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" wrote:

Not another repeat posting !!

Pete

On Feb 10, 1:26 am, tomhelle
wrote:
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 users input. For
example:

Revised Part Qty Automatically assigned €œdash number€�

2 -1
0
0
7 -2

Many thanks in advance!