| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assign unique auto-generated number
Hi there
I want Excel to calculate a new consecutive number based on the last number assigned in a spreadsheet. For example, a batch of raw materials is assigned an SA. No. 13475. The next batch of raw materials will be assigned the SA No. 13476 and so on. I want the next number in the sequence to be available in a drop-down list using the data validation feature. Can anyone help with this? Thanks very much, Silena |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting unique values in a list generated with the OFFSET functio | Excel Worksheet Functions | |||
| Qualifying a generated value as unique across worksheets | Excel Discussion (Misc queries) | |||
| How do I assign a unique ID number to an invoice sheet I created? | Excel Worksheet Functions | |||
| assign auto number and auto date | Excel Discussion (Misc queries) | |||
| How do I assign a unique tracking number in excel? | Excel Worksheet Functions | |||
Linear Mode
