Auto number column giving duplicated numbers

Carmen W

Hi All,

I have an auto number column that I use in a formula to get row# but that auto number column is producing duplicate numbers and therefore messing up the formula.

Does anyone know why it is giving duplicate numbers?

Thanks.

Gia Thinh

I got it. Change the Starting number to the number you want for a new row. Hope this works.

Gia Thinh

Hi Carmen,

It's strange to hear that. Can you show a screenshot to demostrate your situation?

Carmen W

Hi Gia,

Thank you for getting back.

Sure here are some screenshots:

The auto number row is called "RowID"

And here are some duplicated numbers:

Gia Thinh

The numbers in RowID are not in the order of increasing. It seems that the duplicated rows (ex 3624, 3625 at the bottom) are copied from another sheet (B) to your sheet (A). You may want to check this in activity log as below screenshot. If it is the case, you may ask for help from your internal IT.

Carmen W

Hi Gia,

The sheet was created by saving another sheet as a new sheet and that other sheet doesn't have this duplicate number issues.

What's more weird is when I deleted the rows with duplicated numbers and recreated those rows by copy/paste rows within the same sheet, RowID row again produce duplicated numbers, just different ones.

Gia Thinh

I got it. Change the Starting number to the number you want for a new row. Hope this works.

Carmen W

Thank you Gia,

I will do this and hopefully won't see this error again.