| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign unique auto-generated number | Excel Discussion (Misc queries) | |||
| How do I Auto Number a field in Excel - sequential PO# | Excel Worksheet Functions | |||
| How do I assign sequential numbers in an invoice? | New Users to Excel | |||
| How do I assign sequential numbers in an Excel 2003 PO template? | Excel Worksheet Functions | |||
| assign auto number and auto date | Excel Discussion (Misc queries) | |||
Threaded Mode
