ExcelBanter - How do I input for an automatic increment in a cell on Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I input for an automatic increment in a cell on Excel? (https://www.excelbanter.com/excel-worksheet-functions/7177-how-do-i-input-automatic-increment-cell-excel.html)

Rissy

How do I input for an automatic increment in a cell on Excel?

I have made an invoice on Excel. I want the Invoice Numbers to increase by
one each time. How do I do a formula for this?

Frank Kabel

Hi
this is not possible with formulas. This would require VBA. e.g. see:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

"Rissy" wrote:

I have made an invoice on Excel. I want the Invoice Numbers to increase by
one each time. How do I do a formula for this?

All times are GMT +1. The time now is 06:18 AM.