SOLVED

# List/enumerate rows automatically

Copper Contributor

# List/enumerate rows automatically

Hello everyone.

I need help listing the rows on a table, I've been trying so many times but I can't find the way and the formula.

The table is already created and every time i add a row it doesn't take the following number automatically or if take it, the next row doesn't update with the continuously number:

It has to list automatically 1, 2, 3, 4 ... and if I add one row doesn't repeat the number just follow the sequency. Thanks!!!!

2 Replies
best response confirmed by samarmesto (Copper Contributor)
Solution

# Re: List/enumerate rows automatically

@samarmesto If you are using structured table then use-

``=ROW([@Operator])-ROW(Table1[[#Headers],[Operator]])``

If you are using cell range then use-

``=SEQUENCE(ROWS(D4:INDEX(D:D,MATCH("zzz",D:D))))``

# Re: List/enumerate rows automatically

@Harun24HR Thank you so much for your help!

1 best response

Accepted Solutions
best response confirmed by samarmesto (Copper Contributor)
Solution

# Re: List/enumerate rows automatically

@samarmesto If you are using structured table then use-

``=ROW([@Operator])-ROW(Table1[[#Headers],[Operator]])``

If you are using cell range then use-

``=SEQUENCE(ROWS(D4:INDEX(D:D,MATCH("zzz",D:D))))``