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!

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

On Feb 11, 11:55*pm, tomhelle
wrote:
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 user’s input. For
example:

Revised Part Qty * * * * * * *Automatically assigned “dash number”

2 * * * * * * * * * * * * * * * * * * * * * * *-1
0
0
7 * * * * * * * * * * * * * * * * * * * * * * *-2

Many thanks in advance!- Hide quoted text -

- Show quoted text -