| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Next number function
I have an invoice book of 100 invoices. I need something that will
show me the next number to use for the invoice number. The invoice number series (say 10001 - 10100) is set manually on the covering worksheet, but i need something to add the correct number to the invoice, being the next number in the series. Of course I can create a range of numbers to use, but how will one formula in the invoice number cell be used to allow for the next number? Esra TIA |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Next number function
Look he
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html (Site currently down! 15th July 08:30 UK time) "excel" wrote: I have an invoice book of 100 invoices. I need something that will show me the next number to use for the invoice number. The invoice number series (say 10001 - 10100) is set manually on the covering worksheet, but i need something to add the correct number to the invoice, being the next number in the series. Of course I can create a range of numbers to use, but how will one formula in the invoice number cell be used to allow for the next number? Esra TIA |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Next number function
Hi Toppers,
I was going to respond last night/this morning and give the same reference but found the site was down then. Other posters have commented on it being down as well. Pete On Jul 15, 8:28 am, Toppers wrote: Look he http://www.mcgimpsey.com/excel/udfs/sequentialnums.html (Site currently down! 15th July 08:30 UK time) "excel" wrote: I have an invoice book of 100 invoices. I need something that will show me the next number to use for the invoice number. The invoice number series (say 10001 - 10100) is set manually on the covering worksheet, but i need something to add the correct number to the invoice, being the next number in the series. Of course I can create a range of numbers to use, but how will one formula in the invoice number cell be used to allow for the next number? Esra TIA- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function - limit to the number of IFs? | Excel Discussion (Misc queries) | |||
| random number function | Excel Worksheet Functions | |||
| Number range function | Excel Discussion (Misc queries) | |||
| Using the autofill function but increment by certain number in function | Excel Worksheet Functions | |||
| Function for Rounding of Number | Excel Worksheet Functions | |||
Hybrid Mode
