Forum Discussion
samarmesto
Jan 28, 2024Copper 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 ...
- 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.
Harun24HR
Jan 29, 2024Bronze Contributor
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.
samarmesto
Jan 29, 2024Copper Contributor
Harun24HR Thank you so much for your help!