Forum Discussion
SEQUENCE Function inside Excel Table
When I enter the SEQUENCE function within an Excel table I get the #SPILL! error. The specific usage is as follows: =SEQUENCE(COUNTA([Status])) where Status is a defined field name in the table. When...
Your question already contains a potential solution. Entering the formula
= SEQUENCE(ROWS(Table1))
to the left of the table will generate an array of sequence numbers. As SergeiBaklan points out, these are not linked to the individual records so are not suitable for use as a primary key.