List of sequential numbers

[cturner]

I have a list of numbers 1-50.... if I delete a row, I want the
numbers to automatically adjust. The formula I had was
in cell A1 -- 1
In cell A2 -- A1+ 1
IN cell A3 --A2 + 1 etc

If you delete a row, the formulas does not work anymore

any ideas.

Thanks

Chris

 

[T. Valko]

Enter this fomula in A1 and copy down as needed:

=ROW()

 

[Gary''s Student]

In A1 enter:
=ROW() and copy down

 

[cturner]

I have a list of numbers 1-50.... if I delete a row, I want the
numbers to automatically adjust. The formula I had was
in cell A1 -- 1
In cell A2 -- A1+ 1
IN cell A3 --A2 + 1 etc

If you delete a row, the formulas does not work anymore

any ideas.

Thanks

Chris

that is great, but what if I start in cell A3 ... A3 should be 1, A4
should be 2, A5 should be 3 ....

 

[Peo Sjoblom]

Use

=ROW(1:1)


--


Regards,


Peo Sjoblom

that is great, but what if I start in cell A3 ... A3 should be 1, A4
should be 2, A5 should be 3 ....

 

[T. Valko]

Enter 1 in the first cell.

If the first cell is A3 enter this formula in A4 and copy down as needed:

=COUNT(A$3:A3)+1