serial number needs to change automatically
 

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.

serial number needs to change automatically
 

Use =Row() instead of constant numbers 1,2,3, ...
If the first name of your list is in row 2 then use =Row()-1

Regards,
Stefi

€žHelp!!!!!!!!!!€� ezt Ã*rta:

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.

serial number needs to change automatically
 

Not sure I completely understand, a 'before' and 'after' example would help.

But maybe one of these ideas will help.

In 1st row just enter 1 as the 'serial number'. Assume this is row 1 on
your sheet.

In A2 enter formula =A1+1 and fill the formula down (it will become =A2+1,
A3+1, etc as you fill it down the sheet). Then as you delete a row below the
first one, the numbers will change automatically.

Or in A2 enter
=IF(B2="",A1,A1+1)
and again fill that down the sheet. When a name is in the 2nd column, the
number will increase but if there's no name in the 2nd column, then the
number will remain unchanged as:
1 Peter
1
2 Steve

Hope this helps some.

"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.

serial number needs to change automatically
 

It's a pity you started a new thread, but this doesn't explain things
any clearer than your other thread. Have a look there for some further
comments.

Pete

On Feb 19, 12:00*pm, 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.

serial number needs to change automatically
 

for example please see below:
A B
1 Sl No EmpName
2 1 SANTHOSH KUMAR S
3 2 PRAVEEN
4 3 GEETHA R
5 4 PRABHU
6
7 Sl No EmpName
8 1 Pradeep MG
9 2 Bhanu.k.L
10 3 MOHD ISMAIL
11 4 Venkatesh K
12 5 SHARATH K S
13 6 SUNKU PAVAN KUMAR

When I cut the whole row & paste it in the different list it should
automatically align itself with serial number.


"Pete_UK" wrote:

It's a pity you started a new thread, but this doesn't explain things
any clearer than your other thread. Have a look there for some further
comments.

Pete

On Feb 19, 12:00 pm, 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.