creating unique invoice numbers automatically

[CoChic2021chubbrock78]

I can't seem to find the correct formula to have my invoice numbers automatically entered and automatically add 1 to the previous invoice for the "new" invoice number. should be so simple!

[#2]

This works best if your data are in a table (created using Insert > Table). Let's say the first invoice is in row 2 and you want to start with invoice number 1001. Enter the formula =ROW()+999 Excel will automatically propagate the formula to all existing and new rows in the table.