Рет қаралды 1,487
We cover how to create dynamic row numbers in Excel. We cover two methods, one which uses the ROW function which is compatible with earlier versions of excel and one which uses the SEQUENCE function which is more versatile. Both methods ensure the row numbers stay in the correct order even when we delete a row. The SEQUENCE method also incorporates new additions to the numbered list.
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Create Dynamic Row Num...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
theexcelhub@outlook.com
Overview: (0:00)
ROW Method: (1:02)
SEQUENCE Method: (2:47)