Description of formula:
The formula returns the number of the current row in a table. It can only be used in tables and returns the row number based on the current display order of the data.
The formula returns the number of the current row in a table. It can only be used in tables and returns the row number based on the current display order of the data.
The rownumer() formula works dynamically. If row modification is enabled in the table, the numbering is automatically updated after changes, such as adding or deleting a row, which means that the numbers are not permanently assigned to records.
Syntax:
ROWNUMBER()
ROWNUMBER()
Returned type:
Number
Examples:
=ROWNUMBER()
=ROWNUMBER()
Example 1:
The table contains 10 records, and the record with row number 6 belongs to Mateusz Grzelowak.
If the record with row number 6 is deleted, the numbering will be automatically recalculated, and the record of Andrzej Tyczka will receive row number 6.
0 Comments