View Single Post
  #2   Report Post  
 
Posts: n/a
Default


-----Original Message-----
Is there a way to set up a column of numbers so that it

automatically updates
the numbers every time a line is added or deleted?
.
Use =count(A1:A10) or more rows as required.

If its the last row used - =row(B1) extended down to
maybe B100. Then you can use =large(B1:B100) this will
give you the last row used.
Mal