How to use ROW() Excel formula

Any suggestions to use the ROW()

An alternative to get the row number, assuming you want to start from 1:

  • Create a rowID column for the table.

  • Create a lookup column, pointing to the rowID column above to return an array of rowIDs.

  • Use the “find element index” column, use the lookup column as the array, and the rowID column as the value to find. It will return an index for every row starting from 0.

  • Use a math column to add 1 to that index column.


Thank you for this workaround it does the job.

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.