incremental counting?????

S

SBoers

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.
 
P

pmartglass

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
 
M

Max

Another thought, maybe this ..
In A4: =IF(B4="","","1.1.1."&ROWS($1:1))
Copy down. Joy? wave it here, hit YES below
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top