period delimited numbering for Excel sheet?
 

I need to develop an automated method for adding period-delimited
hierarchical numbering of cells. The pattern would be something like:

1.0
....
1.1
1.1.1
....
1.2
1.2.1
1.2.1.1
1.2.1.2
1.2.1.3
1.2.1.3.1
1.2.1.3.2
1.2.1.3.2.1
....
2.0
....
2.1
2.1.1
2.1.2
2.1.2.1
2.1.2.2

etc

how can I do this for and unlimited number of rows? I don't see a standard
format for this.

Thanks for suggestions

Dave G.

period delimited numbering for Excel sheet?
 

You haven't given us any information about the criteria for promoting
or demoting the numbers. This could easily be done with a formula if
you had the data in "helper cells" and defined a rule-set with IF
statements.
You need to define the following:
How will the hierarchy be determined?
How will Excel know to demote to the next level?
How will Excel know to promote up (and how far)?


On Mar 27, 4:24*pm, SledDawg
wrote:
I need to develop an automated method for adding period-delimited
hierarchical numbering of cells. The pattern would be something like:

1.0
...
*1.1
* 1.1.1
...
*1.2
* 1.2.1
* *1.2.1.1
* *1.2.1.2
* *1.2.1.3
* * 1.2.1.3.1
* * 1.2.1.3.2
* * *1.2.1.3.2.1
...
2.0
...
*2.1
* 2.1.1
* 2.1.2
* *2.1.2.1
* *2.1.2.2

etc

how can I do this for and unlimited number of rows? I don't see a standard
format for this.

Thanks for suggestions

Dave G.