| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Documnet Number
I have document numbers (doc#) in this format 5298T800. The 5298 change each day, julian date. The last 2 digits go from 00 to 99 for eac document. I have a column with these document numbers assigned to eac order I make. I would like at the top of that column to know whic document number would be next. So basically it should find the highes doc# and tell me what the next number should be, i.e. 5289T801. Th julian date doesn't need to change unless you know how to program it It will need to start over at zero when it gets to 99 -- Optitro ----------------------------------------------------------------------- Optitron's Profile: http://www.excelforum.com/member.php...fo&userid=2672 View this thread: http://www.excelforum.com/showthread.php?threadid=47847 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif number is greater than a number but less than another number | Excel Discussion (Misc queries) | |||
| How can I click on a telephone number in an Excel 2002 spreadsheet, and have the number dialed? | Excel Discussion (Misc queries) | |||
| How to calculate number of occurencies of a specific number number | Excel Discussion (Misc queries) | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
| Poking Excel data into a Word Documnet | Excel Programming | |||
![Optitron[_24_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
