Formula for serial number

[Guest]

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

 

[Guest]

Try:-

In A1 =ROW(A1)

Drag down and delete a row and see what happens.

Mike

 

[Pete_UK]

You could just use:

=ROW()

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

Hope this helps,

Pete

 

[Guest]

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

is there any other way

 

[Ron Rosenfeld]

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

 

[Guest]

Thanks, it is working perfectly.

Change your formula

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



--ron

 

[Ron Rosenfeld]

Thanks, it is working perfectly.

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