Formula for serial number

S

shaji

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
 
P

Pete_UK

You could just use:

=ROW()

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

Hope this helps,

Pete
 
S

shaji

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

is there any other way
 
R

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
Click to expand...

Change your formula

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



--ron
 
Top