Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
serial no
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
serial no
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
serial no
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
serial no
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
serial numbers | Excel Worksheet Functions | |||
Time Serial | Excel Discussion (Misc queries) | |||
Auto Serial No | Excel Discussion (Misc queries) | |||
Serial No. | Excel Discussion (Misc queries) | |||
Serial Dates | Excel Discussion (Misc queries) |