It took me more than 5 minutes to actually find the right link for my problem to number rows automatically with some correction on where to start.
=ROW()-9
If placed in A10, this will give you 1.
Here's the original article, where I found it from:
http://agsci.psu.edu/it/news/2010/11/automatically-number-rows-in-excel
No comments:
Post a Comment