Forum Discussion

Copper Contributor

Jun 28, 2022

Spill Error in Table while using sequence formula

Hi, I’m trying to get a sequence number dynamically in a table with count of data/rows available. I have attached the error SS, please help. Thanks Ravi

Formulas and Functions

Detlef_Lewin

Silver Contributor

Jun 28, 2022

ravi0408

Excel tables and dynamic array formulas do not work together.

Use something like:

=ROW()-5