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