00:00This is how you can automatically reorder your sequence number in Excel when you delete a row.
00:04We will start with countA function to count the number of non-empty cells in column C,
00:09which will return a value of 21 rows, including the header. Let's remove the header by subtracting
00:14by 1. Now we have 20 rows. To get a sequential number from 1 to 20, we simply encapsulate the
00:20countA function with sequence function. Now if we delete rows, the sequential numbers are still in
00:27order, and even if we add rows, the sequential number increments accordingly.