Using Sequence Function or Something Similar Inside An Excel Table

Hello,

I have two columns, A and B in an Excel Table. In column B, data is entered manually.
Column A needs to be formulated so that it provides a sequential number only if there is data in Column B.
The first sequence number needs to "6612" and then it ascends by +1.

I have used the formula =SEQUENCE(,,6612,1) but it seems this doesn't work on tables.

Any help on this or an alternative to sequence will be appreciated. Noting Rows is another option but am not able to start it from "6612".

Thanks,
Shonal

Try this.

Formula:

Please Login or Register  to view this content.

Originally Posted by DJunqueira

Try this.

Formula:

Please Login or Register  to view this content.

Thanks a lot for this and it serves the purpose for now.
Would it be possible to expand this so we don't get an error message when a row is deleted or a duplicate sequence when a row is inserted?

Thanks,
Shonal

Originally Posted by DJunqueira

Please, update your profile since function SEQUENCE() does not exist in Excel 2010, this is very important for us to offer you the must updated formula.

The header is in row 1.

Formula:

Please Login or Register  to view this content.

Done. Apologies for the oversight

Tks for the update and feedback.