automatic numbering of rows in excel, how to?
On Sep 3, 10:19 am, Spiky wrote:
Put in:
A19: 1
A20: =IF(A19+1B15,"",A19+1)
Copy to A21 and down as far as you will ever need to go. You may want
to alter your print settings after this so it doesn't print the blank
cells.
Oops. One change:
A20: =IF(A19+1$B$15,"",A19+1)
|