Row Numbering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
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?
 
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.
 
Check your formulae again - if you REALLY entered the second value in
B2, then FR-2.1 would show up in *B2*, not *B3*.
 
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?
 
No ideas.

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