serial no
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
On Feb 19, 10:55*am, Help!!!!!!!!!!
wrote:
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- Hide quoted text -
- Show quoted text -
|