Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consequential numbers
I have formulated A2 so i get consequential numbers down column A, however if i insert a new row, the sequence is lost. Is there a way to stop this happening? ------------------------:) -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=510712 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consequential numbers
Your best choice is to use the following formula in A2)
=OFFSET(A2, -1, 0)+1 When you insert a new row, temporarily you will get strange results, but as soon as you copy the formula to the new cells the order will be restored automatically.. HTH Kostis Vezerides |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consequential numbers
An alternative is to use:
=ROW( ) This will always tell you which row you are on, even if you insert or delete rows. However, any formula will have to be copied to a new row if you insert one. Hope this helps. Pete |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consequential numbers
Thanks for the suggestion but i really wanted something that meant i dont have to keep copying the formula in. ----------------------------------------:) -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=510712 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sum top 5 numbers from the column of numbers | Excel Discussion (Misc queries) | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
Validating random numbers | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |