Automatically numbering rows without error
A simple solution to numbering a row even if we delete or add a rows in between the serial numbers.
Formula for numbering the row is “=Row()”
What this formula do Row formula allow us to know the row no. in which we are working.
The question raise how we can use this formula for no the rows?
Answer is simple if you had start the counting from row no 10 then the formula will be “=Row()-9” than the cell will reflect value 1.
No comments:
Post a Comment