Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
incremental counting?????
I am workinging on an .xls spreadsheet with this numbering scheme in Column A.
1 1.1 1.1.1 1.1.1.1 1.1.1.2 1.1.1.3 1.1.1.4 1.1.1.5 1.1.1.6 1.1.1.7 1.1.1.8 1.1.1.9 1.1.1.10 1.1.1.11 how do I get the fourth node to increment on its own, i.e. 12,13,14, once I add data to the next cell over or column B. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
incremental counting?????
if you use a custom format in column A (starting where you have the 1.1.1.11)
use the custom format of "1.1.1."00 then use an if statement to add 1 to the number above something is entered in column B =if(len(b6)0,a5+1,"") copy this formula down for as far as you anticipate needing numbered rows. Hope this is helpful "SBoers" wrote: I am workinging on an .xls spreadsheet with this numbering scheme in Column A. 1 1.1 1.1.1 1.1.1.1 1.1.1.2 1.1.1.3 1.1.1.4 1.1.1.5 1.1.1.6 1.1.1.7 1.1.1.8 1.1.1.9 1.1.1.10 1.1.1.11 how do I get the fourth node to increment on its own, i.e. 12,13,14, once I add data to the next cell over or column B. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
incremental counting?????
Another thought, maybe this ..
In A4: =IF(B4="","","1.1.1."&ROWS($1:1)) Copy down. Joy? wave it here, hit YES below -- Max Singapore --- "SBoers" wrote: I am workinging on an .xls spreadsheet with this numbering scheme in Column A. 1 1.1 1.1.1 1.1.1.1 1.1.1.2 1.1.1.3 1.1.1.4 1.1.1.5 1.1.1.6 1.1.1.7 1.1.1.8 1.1.1.9 1.1.1.10 1.1.1.11 how do I get the fourth node to increment on its own, i.e. 12,13,14, once I add data to the next cell over or column B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incremental charges | Excel Worksheet Functions | |||
incremental counting based on criteria | Excel Discussion (Misc queries) | |||
Incremental References | Excel Worksheet Functions | |||
Incremental comparison | Excel Worksheet Functions | |||
incremental years | Excel Worksheet Functions |