Looking for help generating list numbers with reference
 

I'm trying to create several tables on top of each other where the
tables start at 1 and continue on until the end of the list.
Currently, I have the numbering where row one, is shown as "1", and
then row two has a "=A1+1". I can then copy the row two formula for
the remaining cells, and it adds accordingly.

The problem is, if I start deleting rows, then all the rows below the
deleted row get REF! errors. What's the easiest way to avoid this? I
would like a dynamically stable list that will keep it's numbering
correct as I add and remove rows. Is there a way to do this with a
CELL() function perhaps?

Let me know if I need to explain further.


--
Excl
------------------------------------------------------------------------
Excl's Profile: http://www.excelforum.com/member.php...o&userid=37897
View this thread: http://www.excelforum.com/showthread...hreadid=574315

Looking for help generating list numbers with reference
 

Try this instead, copied down........

=ROW()

Vaya con Dios,
Chuck, CABGx3



"Excl" wrote:


I'm trying to create several tables on top of each other where the
tables start at 1 and continue on until the end of the list.
Currently, I have the numbering where row one, is shown as "1", and
then row two has a "=A1+1". I can then copy the row two formula for
the remaining cells, and it adds accordingly.

The problem is, if I start deleting rows, then all the rows below the
deleted row get REF! errors. What's the easiest way to avoid this? I
would like a dynamically stable list that will keep it's numbering
correct as I add and remove rows. Is there a way to do this with a
CELL() function perhaps?

Let me know if I need to explain further.


--
Excl
------------------------------------------------------------------------
Excl's Profile: http://www.excelforum.com/member.php...o&userid=37897
View this thread: http://www.excelforum.com/showthread...hreadid=574315