numbered cells

[barryhill]

Hi

Is it possible to number a stack of rows in Planmaker so that, if a line is deleted or added, the numbering corrects itself?

thanks


Barry

[miguel-c]

Yes, a good solution is to use the ROW() function.
1. Go to A1 and type:
=row()+1000
2. Drag the corner of A1 downwards
3. If you now delete one of the rows, the count is resumed
Note: 1000 is the offset. You can delete it if you want to start at 1 or change to any number of your choosing