Forum Discussion

samarmesto's avatar
samarmesto
Copper Contributor
Jan 28, 2024
Solved

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!!!!

 

 

BI & Data Analysis
excel
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Jan 29, 2024

    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.

     

Resources