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...
Thanks for the reply Patrick. I'm just trying to create a auto-generated number for each record in my table. I know there are multiple ways to accomplish this but until now SEQUENCE has always worked well for me.
Depending on where the table starts in your sheet row-wise, you could use the ROW function.
Let's say the table starts at row 1 with the header and records following start at row 2. Then the formula would be:
=ROW()-1