Auto serial number in excel based on another column

Unlike other Microsoft Office programs, Excel does not provide a button to auto number in excel.

Adding serial numbers manually is a pain.

Moreover, they will be static and will not renumber automatically by adding or removing records.

Product IDs, serial numbers for transactions require a unique identifier, that skips blanks & renumbers automatically when adding or deleting records.

You can download the exercise file and follow along by clicking on the button here below

in this worksheet I want to create a column of incremental numbers

and I’m going to start with a very basic example.

Select cell A4 and type number 1, then hit enter.
Now if I hover over the lower right corner (mouse pointer changes to a tiny plus sign) the autofill handle, I press control while dragging all the way down And I would have created a column of incremental numbers.

Unfortunately, this column has lots of problems:

• The first thing it is counting the blanks.
• If I delete a record or if I add a new record nothing cha
  how to create automatic serial number in excel
  how to create automatic invoice number in excel