Forum Discussion
creating unique invoice numbers automatically
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!
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.