creating unique invoice numbers automatically

%3CLINGO-SUB%20id%3D%22lingo-sub-3084496%22%20slang%3D%22en-US%22%3Ecreating%20unique%20invoice%20numbers%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3084496%22%20slang%3D%22en-US%22%3E%3CP%20style%3D%22%20text-align%20%3A%20left%3B%20%22%3E%3CFONT%20color%3D%22%23000080%22%3EI%20can't%26nbsp%3Bseem%20to%20find%20the%20correct%20formula%20to%20have%20my%20invoice%20numbers%20automatically%20entered%20and%20automatically%20add%201%20to%20the%20previous%20invoice%20for%20the%20%22new%22%20invoice%20number.%20should%20be%20so%20simple!%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3084496%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3085035%22%20slang%3D%22en-US%22%3ERe%3A%20creating%20unique%20invoice%20numbers%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3085035%22%20slang%3D%22en-US%22%3EThis%20works%20best%20if%20your%20data%20are%20in%20a%20table%20(created%20using%20Insert%20%26gt%3B%20Table).%20Let's%20say%20the%20first%20invoice%20is%20in%20row%202%20and%20you%20want%20to%20start%20with%20invoice%20number%201001.%20Enter%20the%20formula%20%3DROW()%2B999%20Excel%20will%20automatically%20propagate%20the%20formula%20to%20all%20existing%20and%20new%20rows%20in%20the%20table.%3C%2FLINGO-BODY%3E
Occasional Visitor

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!

1 Reply
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.