List of sequential numbers
 

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

List of sequential numbers
 

Enter this fomula in A1 and copy down as needed:

=ROW()

--
Biff
Microsoft Excel MVP


wrote in message
...
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

List of sequential numbers
 

In A1 enter:
=ROW() and copy down
--
Gary''s Student - gsnu2007h

List of sequential numbers
 

On May 16, 10:59 am, wrote:
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 ....

List of sequential numbers
 

Use

=ROW(1:1)


--


Regards,


Peo Sjoblom


wrote in message
...
On May 16, 10:59 am, wrote:
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 ....

List of sequential numbers
 

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

--
Biff
Microsoft Excel MVP


wrote in message
...
On May 16, 10:59 am, wrote:
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 ....