Please Help Me Increment Numbers in My Cells

Originally Posted by popipipo

Please Login or Register  to view this content.

Try this formula

This worked great. Thanks!

Put the number 1 in the first cell (assume this is A1). Then you can use this formula in cell A2:

=ROWS($1:1)+A1

and copy it down as far as you like.

Hope this helps.

Pete

Originally Posted by Pete_UK

Put the number 1 in the first cell (assume this is A1). Then you can use this formula in cell A2:

=ROWS($1:1)+A1

and copy it down as far as you like.

Hope this helps.

Pete

Thanks! this one worked even better

Glad to help, and thanks for the rep.

Pete