Creating a Table with Automatic Row Numbering
When creating an Excel Table, you may use a calculation relying on the ROW function to insert row numbers automatically. The formula in A2, which has been copied down, is as follows: =ROW()-ROW(Table1[#Headers]) Note: the default table name is Table1. And #Headers is the header in the Table1. Let’s See How This Formula Works: When… read more »