serial no

  • Thread starter Thread starter Help!!!!!!!!!!
  • Start date Start date
H

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
 
I don't think anyone would understand what you mean by "juggaled up &
down". Could you please rephrase your problem?

Pete
 
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.
 
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
 
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
 
Back
Top