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

C

CBapex homes

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
[email protected]
 
B

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
 
R

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,
Click to expand...

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
__________________________
 
Top