Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

List/enumerate rows automatically

Copper Contributor

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:

samarmesto_0-1706483713461.png

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

@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))))

 Download the attached file.

Harun24HR_0-1706494270081.png

 

@Harun24HR Thank you so much for your help!

1 best response

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

@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))))

 Download the attached file.

Harun24HR_0-1706494270081.png

 

View solution in original post