Forum Discussion

samarmesto's avatar
samarmesto
Copper Contributor
Jan 28, 2024

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 ...
  • Harun24HR's avatar
    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