Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have labels in column A - 1.1, 1.2, 1.3 ... 2.1, 2.2....5.1, etc.
Instead of the A2=A1+.11, is there an alternate formula that will allow for entering a new row in the middle of a sequence and having the subsequent entries renumber correctly? When I insert a new line in the middle (e.g., between A4 and A5) I get a blank A5 and now A6 shows A4+.1 and not the desired A5+.1. I'm happy to manually enter A4+.1 into the new A5. I know I could probably just redrag the autofill, but it becomes tedious and I've got to think someone smarter than me can figure this out =) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |