S
Sherry Lynn Harrington
I would like to write a formula that would number the rows
automatically. The spreadsheet would have the structure below.
X.Y = main heading; X would vary with each worksheet created
(numeric). The user could input the value for X in say cell a1 and
then this first row of information (which might start at row 15) could
reference a1 for the value of X.
X.Y.1 and up = bulleted headings - there could be one or many
bulleted sub headings that would be numbered sequentially. I would
preferabley like to use a formula rather than VB as there will be many
other users (not particularly skilled in excel).
I have read similar questions on this forum and tried to implement the
solutions offered but none seems to work for my scenario. I was
trying to write an IF statement based on whether the text in row B
starts with a bullet character but I haven't been able to get the
level with the bulleted text to increment by 1 and the the next non-
bulleted line to change to the next level ie. "2". Any help would be
greatly appreciated!
This is a sample spreadsheet: where 10.1 is in A15, Text is in B15:
10.1 Text
10.1.1 · text
10.1.2 · text
10.2 Text
10.2.1 · text
10.2.2 · text
10.2.3 · text
10.3 Text
10.3.1 · text
10.3.2 · text
10.4 Text
10.5 Text
10.6 Text
Subtotal
Some Title
10.7 Text
10.7.1 · text
10.7.2 · text
10.7.3 · text
automatically. The spreadsheet would have the structure below.
X.Y = main heading; X would vary with each worksheet created
(numeric). The user could input the value for X in say cell a1 and
then this first row of information (which might start at row 15) could
reference a1 for the value of X.
X.Y.1 and up = bulleted headings - there could be one or many
bulleted sub headings that would be numbered sequentially. I would
preferabley like to use a formula rather than VB as there will be many
other users (not particularly skilled in excel).
I have read similar questions on this forum and tried to implement the
solutions offered but none seems to work for my scenario. I was
trying to write an IF statement based on whether the text in row B
starts with a bullet character but I haven't been able to get the
level with the bulleted text to increment by 1 and the the next non-
bulleted line to change to the next level ie. "2". Any help would be
greatly appreciated!
This is a sample spreadsheet: where 10.1 is in A15, Text is in B15:
10.1 Text
10.1.1 · text
10.1.2 · text
10.2 Text
10.2.1 · text
10.2.2 · text
10.2.3 · text
10.3 Text
10.3.1 · text
10.3.2 · text
10.4 Text
10.5 Text
10.6 Text
Subtotal
Some Title
10.7 Text
10.7.1 · text
10.7.2 · text
10.7.3 · text