Forum Discussion
GoldenBomb
May 13, 2023Copper Contributor
Excel Row Array Help
I'm trying to follow a tutorial where after creating a table, you can add a formula with =row(table). It then automatically creates a list of all the active rows of the table. Apparently this is a fe...
SergeiBaklan
May 13, 2023Diamond Contributor
=ROW(Table1)
shall work in 2016 with Ctrl+Shift+Enter formula entered. In formula bar after that it shall be rounded with {}. No other workarounds.