I have a sheet where data is being added to the last empty row and inserting the new row between the rows which has already data.

I want to create a Unique Numeric number that will be 0 to upward in sequence. Like we use =IF(B3<>"",B2 1,"").

But when new row is added the formula is missed I want to Add unique number for each row.

I have tried with that

CodePudding user response：

In the top row,

=ARRAYFORMULA({"ID";SEQUENCE(COUNTA(B:B) 0)})

Change 0 to 1 or 2, if you want some blank row offset.

CodePudding user response：

ALTERNATIVE SUGGESTION

If I have understood your goal correctly, you may also try this custom script ID below that you can

The custom script adjusts when there are newly added data:

The custom function also adjusts when there's an empty row in between the range: