Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to identify a list of numbers as a publisher field | Excel Discussion (Misc queries) | |||
find sum in list of of numbers | Excel Discussion (Misc queries) | |||
find sum in list of of numbers | New Users to Excel | |||
find sum in list of of numbers | Excel Discussion (Misc queries) | |||
How do I filter a number list by numbers to the right of the decim | Excel Worksheet Functions |