sir,

In my range of data, the first column is of serial number where in I put 1
in A1 and use the formula A1+1 in A2 and copying the same downwards. It
works perfectly unless I delete a row the range. When I delete a row #REF!
will appear in the remaining rows. Is any way to avoid this, i mean , when I
delete a row the formula should catch the number in the above row +1 in the
next.

please help

Try:-

In A1 =ROW(A1)

Drag down and delete a row and see what happens.

Mike

"shaji" wrote:

sir,

In my range of data, the first column is of serial number where in I put 1
in A1 and use the formula A1+1 in A2 and copying the same downwards. It
works perfectly unless I delete a row the range. When I delete a row #REF!
will appear in the remaining rows. Is any way to avoid this, i mean , when I
delete a row the formula should catch the number in the above row +1 in the
next.

please help

You could just use:

=ROW()

to generate your sequence. This would automatically adjust if you
delete a row.

Hope this helps,

Pete


On Jun 25, 10:41 am, shaji wrote:
sir,

In my range of data, the first column is of serial number where in I put 1
in A1 and use the formula A1+1 in A2 and copying the same downwards. It
works perfectly unless I delete a row the range. When I delete a row #REF!
will appear in the remaining rows. Is any way to avoid this, i mean , when I
delete a row the formula should catch the number in the above row +1 in the
next.

please help

It works only when the serial number is same as of the row number.

is there any other way



"Pete_UK" wrote:

You could just use:

=ROW()

to generate your sequence. This would automatically adjust if you
delete a row.

Hope this helps,

Pete


On Jun 25, 10:41 am, shaji wrote:
sir,

In my range of data, the first column is of serial number where in I put 1
in A1 and use the formula A1+1 in A2 and copying the same downwards. It
works perfectly unless I delete a row the range. When I delete a row #REF!
will appear in the remaining rows. Is any way to avoid this, i mean , when I
delete a row the formula should catch the number in the above row +1 in the
next.

please help

On Mon, 25 Jun 2007 02:41:03 -0700, shaji
wrote:

sir,

In my range of data, the first column is of serial number where in I put 1
in A1 and use the formula A1+1 in A2 and copying the same downwards. It
works perfectly unless I delete a row the range. When I delete a row #REF!
will appear in the remaining rows. Is any way to avoid this, i mean , when I
delete a row the formula should catch the number in the above row +1 in the
next.

please help

Change your formula

A2: =$A$1+ROWS($1:1)



--ron

Thanks, it is working perfectly.

"Ron Rosenfeld" wrote:

On Mon, 25 Jun 2007 02:41:03 -0700, shaji
wrote:

sir,

In my range of data, the first column is of serial number where in I put 1
in A1 and use the formula A1+1 in A2 and copying the same downwards. It
works perfectly unless I delete a row the range. When I delete a row #REF!
will appear in the remaining rows. Is any way to avoid this, i mean , when I
delete a row the formula should catch the number in the above row +1 in the
next.

please help

Change your formula

A2: =$A$1+ROWS($1:1)



--ron

On Mon, 25 Jun 2007 04:51:00 -0700, shaji
wrote:

Thanks, it is working perfectly.

You're welcome. Glad to help.
--ron