Posted to microsoft.public.excel.worksheet.functions
|
|
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
|