Trying to automatically number a spreadsheet that has a couple of columns
with multiple rows and keep the numbering straight. Scenario below:

A B
First Second
Column Column

1)BR-1
2)BR-2
3)BR-3
4) FR-3.1
5) FR-3.2
6)BR-4

Two things I am trying to accomplish, in column A, sequential numbering but
with skipped rows, and in column B, it would follow the numbering in column
A, but only corresponding to the appropriate BR number. So if BR-3 had FRs,
then the FR would number sequentially.

Any help would be appreciated.

One way:

Format column A with Format/Cells/Number/Custom "BR-"0
Format column B with Format/Cells/Number/Custom "FR-"0.0

Then

A1: 1
A2: =MAX($A$1:$A1)+1

B2: =IF(A2="",MAX(A1,B1)+0.1,"")

Copy A2 & B2 down as far as required.

To create the numbering in column B, clear the corresponding cell(s) in
column A.


In article ,
ironman wrote:

Trying to automatically number a spreadsheet that has a couple of columns
with multiple rows and keep the numbering straight. Scenario below:

A B
First Second
Column Column

1)BR-1
2)BR-2
3)BR-3
4) FR-3.1
5) FR-3.2
6)BR-4

Two things I am trying to accomplish, in column A, sequential numbering but
with skipped rows, and in column B, it would follow the numbering in column
A, but only corresponding to the appropriate BR number. So if BR-3 had FRs,
then the FR would number sequentially.

Any help would be appreciated.

JE,

This is what is showing up after I input the macro:

A B
Row 1: BR-1
Row 2: BR-2
Row 3:
Row 4: BR-3 FR-0.1
Row 5:
Row 6: FR-0.1
Row 7: BR-4 FR-0.2
Row 8: BR-5
Row 9: BR-6

How to tweak?




"JE McGimpsey" wrote:

One way:

Format column A with Format/Cells/Number/Custom "BR-"0
Format column B with Format/Cells/Number/Custom "FR-"0.0

Then

A1: 1
A2: =MAX($A$1:$A1)+1

B2: =IF(A2="",MAX(A1,B1)+0.1,"")

Copy A2 & B2 down as far as required.

To create the numbering in column B, clear the corresponding cell(s) in
column A.


In article ,
ironman wrote:

Trying to automatically number a spreadsheet that has a couple of columns
with multiple rows and keep the numbering straight. Scenario below:

A B
First Second
Column Column

1)BR-1
2)BR-2
3)BR-3
4) FR-3.1
5) FR-3.2
6)BR-4

Two things I am trying to accomplish, in column A, sequential numbering but
with skipped rows, and in column B, it would follow the numbering in column
A, but only corresponding to the appropriate BR number. So if BR-3 had FRs,
then the FR would number sequentially.

Any help would be appreciated.

Adding more info:

I tweaked the following:

B2: =IF(A2="",MAX(A1,B1)+0.1,"")

to

B2: =IF(A2<"",MAX(A1,B1)+0.1,""),

Now it displays the following:

A B

Row 1: BR-1
Row 2: BR-2
Row 3: FR-2.1
Row 4:
Row 5:
Row 6: BR-3

How do I continue the numbering in Row 4 (FR-2.2) and row 5 (FR-2.3)?

Thanks for your help?



"ironman" wrote:

JE,

This is what is showing up after I input the macro:

A B
Row 1: BR-1
Row 2: BR-2
Row 3:
Row 4: BR-3 FR-0.1
Row 5:
Row 6: FR-0.1
Row 7: BR-4 FR-0.2
Row 8: BR-5
Row 9: BR-6

How to tweak?




"JE McGimpsey" wrote:

One way:

Format column A with Format/Cells/Number/Custom "BR-"0
Format column B with Format/Cells/Number/Custom "FR-"0.0

Then

A1: 1
A2: =MAX($A$1:$A1)+1

B2: =IF(A2="",MAX(A1,B1)+0.1,"")

Copy A2 & B2 down as far as required.

To create the numbering in column B, clear the corresponding cell(s) in
column A.


In article ,
ironman wrote:

Trying to automatically number a spreadsheet that has a couple of columns
with multiple rows and keep the numbering straight. Scenario below:

A B
First Second
Column Column

1)BR-1
2)BR-2
3)BR-3
4) FR-3.1
5) FR-3.2
6)BR-4

Two things I am trying to accomplish, in column A, sequential numbering but
with skipped rows, and in column B, it would follow the numbering in column
A, but only corresponding to the appropriate BR number. So if BR-3 had FRs,
then the FR would number sequentially.

Any help would be appreciated.

What macro?

What you've shown isn't possible if you entered the formulae I gave you.
It looks like you offset the formulae in column B.


In article ,
ironman wrote:

JE,

This is what is showing up after I input the macro:

A B
Row 1: BR-1
Row 2: BR-2
Row 3:
Row 4: BR-3 FR-0.1
Row 5:
Row 6: FR-0.1
Row 7: BR-4 FR-0.2
Row 8: BR-5
Row 9: BR-6

How to tweak?




"JE McGimpsey" wrote:

One way:

Format column A with Format/Cells/Number/Custom "BR-"0
Format column B with Format/Cells/Number/Custom "FR-"0.0

Then

A1: 1
A2: =MAX($A$1:$A1)+1

B2: =IF(A2="",MAX(A1,B1)+0.1,"")

Copy A2 & B2 down as far as required.

To create the numbering in column B, clear the corresponding cell(s) in
column A.


In article ,
ironman wrote:

Trying to automatically number a spreadsheet that has a couple of columns
with multiple rows and keep the numbering straight. Scenario below:

A B
First Second
Column Column

1)BR-1
2)BR-2
3)BR-3
4) FR-3.1
5) FR-3.2
6)BR-4

Two things I am trying to accomplish, in column A, sequential numbering
but
with skipped rows, and in column B, it would follow the numbering in
column
A, but only corresponding to the appropriate BR number. So if BR-3 had
FRs,
then the FR would number sequentially.

Any help would be appreciated.

Check your formulae again - if you REALLY entered the second value in
B2, then FR-2.1 would show up in *B2*, not *B3*.

In article ,
ironman wrote:

Adding more info:

I tweaked the following:

B2: =IF(A2="",MAX(A1,B1)+0.1,"")

to

B2: =IF(A2<"",MAX(A1,B1)+0.1,""),

Now it displays the following:

A B

Row 1: BR-1
Row 2: BR-2
Row 3: FR-2.1
Row 4:
Row 5:
Row 6: BR-3

How do I continue the numbering in Row 4 (FR-2.2) and row 5 (FR-2.3)?

Thanks for your help?



"ironman" wrote:

JE,

This is what is showing up after I input the macro:

A B
Row 1: BR-1
Row 2: BR-2
Row 3:
Row 4: BR-3 FR-0.1
Row 5:
Row 6: FR-0.1
Row 7: BR-4 FR-0.2
Row 8: BR-5
Row 9: BR-6

How to tweak?




"JE McGimpsey" wrote:

One way:

Format column A with Format/Cells/Number/Custom "BR-"0
Format column B with Format/Cells/Number/Custom "FR-"0.0

Then

A1: 1
A2: =MAX($A$1:$A1)+1

B2: =IF(A2="",MAX(A1,B1)+0.1,"")

Copy A2 & B2 down as far as required.

To create the numbering in column B, clear the corresponding cell(s) in
column A.


In article ,
ironman wrote:

Trying to automatically number a spreadsheet that has a couple of
columns
with multiple rows and keep the numbering straight. Scenario below:

A B
First Second
Column Column

1)BR-1
2)BR-2
3)BR-3
4) FR-3.1
5) FR-3.2
6)BR-4

Two things I am trying to accomplish, in column A, sequential numbering
but
with skipped rows, and in column B, it would follow the numbering in
column
A, but only corresponding to the appropriate BR number. So if BR-3 had
FRs,
then the FR would number sequentially.

Any help would be appreciated.

Meant "the second formula"

In article ,
JE McGimpsey wrote:

the second value

I actually want FR-2.1 to show up in B3, not B2.

Problem is that the formula doesn't populate anything in B4 and B5.

Any ideas?


"JE McGimpsey" wrote:

Check your formulae again - if you REALLY entered the second value in
B2, then FR-2.1 would show up in *B2*, not *B3*.

In article ,
ironman wrote:

Adding more info:

I tweaked the following:

B2: =IF(A2="",MAX(A1,B1)+0.1,"")

to

B2: =IF(A2<"",MAX(A1,B1)+0.1,""),

Now it displays the following:

A B

Row 1: BR-1
Row 2: BR-2
Row 3: FR-2.1
Row 4:
Row 5:
Row 6: BR-3

How do I continue the numbering in Row 4 (FR-2.2) and row 5 (FR-2.3)?

Thanks for your help?



"ironman" wrote:

JE,

This is what is showing up after I input the macro:

A B
Row 1: BR-1
Row 2: BR-2
Row 3:
Row 4: BR-3 FR-0.1
Row 5:
Row 6: FR-0.1
Row 7: BR-4 FR-0.2
Row 8: BR-5
Row 9: BR-6

How to tweak?




"JE McGimpsey" wrote:

One way:

Format column A with Format/Cells/Number/Custom "BR-"0
Format column B with Format/Cells/Number/Custom "FR-"0.0

Then

A1: 1
A2: =MAX($A$1:$A1)+1

B2: =IF(A2="",MAX(A1,B1)+0.1,"")

Copy A2 & B2 down as far as required.

To create the numbering in column B, clear the corresponding cell(s) in
column A.


In article ,
ironman wrote:

Trying to automatically number a spreadsheet that has a couple of
columns
with multiple rows and keep the numbering straight. Scenario below:

A B
First Second
Column Column

1)BR-1
2)BR-2
3)BR-3
4) FR-3.1
5) FR-3.2
6)BR-4

Two things I am trying to accomplish, in column A, sequential numbering
but
with skipped rows, and in column B, it would follow the numbering in
column
A, but only corresponding to the appropriate BR number. So if BR-3 had
FRs,
then the FR would number sequentially.

Any help would be appreciated.

No ideas.

What I've posted works in my test workbook exactly as your post says you
want.

In article ,
ironman wrote:

I actually want FR-2.1 to show up in B3, not B2.

Problem is that the formula doesn't populate anything in B4 and B5.

Any ideas?