ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Row Numbering (https://www.excelbanter.com/excel-discussion-misc-queries/159075-row-numbering.html)

ironman
Row Numbering
 
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 McGimpsey
Row Numbering
 
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.

ironman
Row Numbering
 
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.

ironman
Row Numbering
 
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.

JE McGimpsey
Row Numbering
 
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.

JE McGimpsey
Row Numbering
 
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.

JE McGimpsey
Row Numbering
 
Meant "the second formula"

In article ,
JE McGimpsey wrote:

the second value

ironman
Row Numbering
 
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.

JE McGimpsey
Row Numbering
 
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?


All times are GMT +1. The time now is 01:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com