T
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
that will automatically recalculate 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!
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
that will automatically recalculate 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!