Hi
Not very clear but if you're deleting the rows and keep the order with your
numbers,
use =Row() to number your rows.
If your starting e.g. at A2 your formula will be =Row()-1 that will give you 1
HTH
John
"Help!!!!!!!!!!" wrote in message
...
I have a list of names in the single column were I keep changing the names
row very often, so what I want is" the serial number in the column needs to
change automatically in to series".
Eg

1 peter
2 charles
3 stev

If I cut Charles & place in the 1 st place number needs to change
automatically.

"Pete_UK" wrote:

I don't think anyone would understand what you mean by "juggaled up &
down". Could you please rephrase your problem?

Pete

On Feb 19, 7:56 am, Help!!!!!!!!!!
wrote:
hi ,

i have list of name & serial no, when the name is juggaled up & down the
serial no needs to in series.

Please help me with the formula.............!

Regadrs,
Manjunath