xforgive the lack of ecel lingo, but...

i'm trying to create a column of sequential numbers. right now i have the
formula a2=a1+1, a3=a2+1, etc. if i delete row 4 (for example), all numbers
downward are in error, since the a4 formula is erased. is there anyway to
delete a row without disrupting the sequence? can they be reformulated
automatically?

=ROW() in your cells.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"DL" wrote in message
...
xforgive the lack of ecel lingo, but...

i'm trying to create a column of sequential numbers. right now i have the
formula a2=a1+1, a3=a2+1, etc. if i delete row 4 (for example), all
numbers
downward are in error, since the a4 formula is erased. is there anyway to
delete a row without disrupting the sequence? can they be reformulated
automatically?

sorry--what goes in the ( )? i tried entering "2" for row 2 or "b2" for cell
b2, but i still get an error message...

"Ken Wright" wrote:

=ROW() in your cells.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"DL" wrote in message
...
xforgive the lack of ecel lingo, but...

i'm trying to create a column of sequential numbers. right now i have the
formula a2=a1+1, a3=a2+1, etc. if i delete row 4 (for example), all
numbers
downward are in error, since the a4 formula is erased. is there anyway to
delete a row without disrupting the sequence? can they be reformulated
automatically?

Entered in A1 & copied down:

=ROW()-ROW(INDEX(A:A,1))+1

would cause no disruption even if row 1 is deleted.

DL wrote:
xforgive the lack of ecel lingo, but...

i'm trying to create a column of sequential numbers. right now i have the
formula a2=a1+1, a3=a2+1, etc. if i delete row 4 (for example), all numbers
downward are in error, since the a4 formula is erased. is there anyway to
delete a row without disrupting the sequence? can they be reformulated
automatically?

ok, i see. =ROW( ) keeps the series of numbers in the column when i delete a
cell. BUT, i'd like to delete the entire row and have the series in the
column adjust accordingly.
First,
1
2
3
4
5
Then, delete row 3. 4 and 5 move up and change to 3 and 4, respectively.

"Ken Wright" wrote:

=ROW() in your cells.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"DL" wrote in message
...
xforgive the lack of ecel lingo, but...

i'm trying to create a column of sequential numbers. right now i have the
formula a2=a1+1, a3=a2+1, etc. if i delete row 4 (for example), all
numbers
downward are in error, since the a4 formula is erased. is there anyway to
delete a row without disrupting the sequence? can they be reformulated
automatically?

That's exactly what it does, but see Aladin's response for a fuller reply.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"DL" wrote in message
...
ok, i see. =ROW( ) keeps the series of numbers in the column when i
delete a
cell. BUT, i'd like to delete the entire row and have the series in the
column adjust accordingly.
First,
1
2
3
4
5
Then, delete row 3. 4 and 5 move up and change to 3 and 4, respectively.

"Ken Wright" wrote:

=ROW() in your cells.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)

--------------------------------------------------------------------------
--

"DL" wrote in message
...
xforgive the lack of ecel lingo, but...

i'm trying to create a column of sequential numbers. right now i have
the
formula a2=a1+1, a3=a2+1, etc. if i delete row 4 (for example), all
numbers
downward are in error, since the a4 formula is erased. is there
anyway to
delete a row without disrupting the sequence? can they be
reformulated
automatically?

thank you both!

"Aladin Akyurek" wrote:

Entered in A1 & copied down:

=ROW()-ROW(INDEX(A:A,1))+1

would cause no disruption even if row 1 is deleted.

DL wrote:
xforgive the lack of ecel lingo, but...

i'm trying to create a column of sequential numbers. right now i have the
formula a2=a1+1, a3=a2+1, etc. if i delete row 4 (for example), all numbers
downward are in error, since the a4 formula is erased. is there anyway to
delete a row without disrupting the sequence? can they be reformulated
automatically?