delete row and automatically renumber column

[Graham Hill]

This is probably a piece of cake for this NG : -

(For example) I have a small data base (any # of columns by any # of rows)
I wish to delete an entry and have the left side column automatically
renumber itself rather than having to manually (drag) to renumber the
column. Is this possible? Please help.

Thanks,
Gra

 

[Don Guillett]

The numbers do not change when you delete a row. If you are using a column
with row numbers in in why not substitute the row function in the formula
instead

or
=row()
or
=row(a5) and copy down

 

[Gord Dibben]

Graham

Assuming you have your numbers in Column A.

In A1(or A2 if you have titles in row 1) enter =ROW() and drag/copy down.

When you delete a row the numbers will update.

When you insert a row you will have to copy just from the row above to the
inserted row.

Gord Dibben XL2002

 

[David McRitchie]

Hi Graham,
A slight variation of Gord's reply is probably what you are
looking for.
A1: '#
A2: =ROW() -1
since you probably want to avoid numbering the row with
your own column labels. ROW() is going to report the row
number that the formula is in.