serial no

[Help!!!!!!!!!!]

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

 

[Pete_UK]

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

Pete

 

[Help!!!!!!!!!!]

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]

I still don't understand what you want to end up with. Here are some
examples, after you cut/paste Charles to overwrite Peter:

1 charles
2
3 stev

i.e. no change to the numbers, or:

1 charles
-
3 stev

where the - could represent a blank cell, but the other numbers remain
unchanged, or:

1 charles
-
2 stev

where - again could be blank, but other numbers are changed to
represent the number of names that you have, or:

2 charles
-
3 stev

the number follows charles.

I can think of other things that you might want to happen, so please
explain what it is that you want.

Pete

 

[John]

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