How can I get a row # to stay when I delete a row?

[Guest]

How can I get a row # to stay when I delete a row? I have a company roster
set up but, every time I delete a person from our roster it changes the order
of the #. Example: 1
2
3
4


And I take away #3 and I am left with:
1
2
4.
It doesn’t automatically change the 4 to the deleted 3. What can I do to
were every time I delete someone it will automatically arrange it self in
order from 1-400 with no blank spots.


Help anyone please.


Thank you in Advance,

Denise Ortiz
(e-mail address removed)

 

[Biff]

Hi!

One way:

Assume you have the numbers in A2:An

In column B, B2:Bn are names

Replace the numbers in column A with this formula by entering it in A2 and
copying down as needed.

=COUNTA(B$2:B2)

Biff

 

[KL]

based on Biff's assumptions, another way could be:

=ROW()-1

Regards,
KL

 

[Richard Buttrey]

On Thu, 22 Sep 2005 14:27:03 -0700, CBapex homes <CBapex

How can I get a row # to stay when I delete a row? I have a company roster
set up but, every time I delete a person from our roster it changes the order
of the #. Example: 1
2
3
4


And I take away #3 and I am left with:
1
2
4.
It doesn’t automatically change the 4 to the deleted 3. What can I do to
were every time I delete someone it will automatically arrange it self in
order from 1-400 with no blank spots.


Help anyone please.


Thank you in Advance,

Use the formula

=Row()

Include a constant if necessary, if your data does not start in row 1

i.e. =Row()+5 if your data starts in row 5

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________