Put A Row Number On A Table

less than 1 minute read

Here’s a simple way to get the row number of the table items.
It’s a simple formula referencing the current cell’s row minus the row number of the table header row.

In this example I’ve changed the table name to MyTable

=ROW()-ROW(MyTable[[#Headers],[Row '#]])

Tags: tables

Categories: formulas

Updated: September 16, 2019

Twitter Facebook LinkedIn

Leave a Comment