| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automated Generated Numbers
I have to create invoices on Excel. How should i make certain that when the
invoice is opened, a new invoice number is generated? SO that there are no duplicates. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automated Generated Numbers
Look he
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Madiha" wrote in message ... |I have to create invoices on Excel. How should i make certain that when the | invoice is opened, a new invoice number is generated? SO that there are no | duplicates. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automated Generated Numbers
On Nov 26, 1:31 pm, "Niek Otten" wrote:
Look he http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Madiha" wrote in ... |I have to create invoices on Excel. How should i make certain that when the | invoice is opened, a new invoice number is generated? SO that there are no | duplicates. If you are storing invoices on another spreadsheet for future use. I know my company does. You can use the Max() +1. You type =MAX( Then choose the spreadsheet and array that you want to compare it to close parenthases) and off you go. Jay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Corrosponding excel generated numbers with 1st row numbers | Excel Worksheet Functions | |||
| Difficulty adding RAND generated numbers | Excel Discussion (Misc queries) | |||
| I want random numbers generated without repeating numbers | Excel Worksheet Functions | |||
| to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
| How do I add the sum of a series numbers generated by Rnd gen? | Excel Worksheet Functions | |||
Linear Mode
