Numbering a column if a string is recognised in the adjacent column

Hi
What I want to do is label the first column a value if the specific branch is found in the adjacent column. When the next branch is found it starts putting the next value in the column.

1 Branch1
1 Name Account
1 Name Account
1 Name Account
1 Name Account
1 Name Account
1 Name Account

2 Branch2
2 Name Account
2 Name Account
2 Name Account
2 Name Account

3 Branch3
3 Name Account
3 Name Account
3 Name Account
3 Name Account

Help Please

Hi,

Suppose you want to number column A (starting at A2), and the "Branchx" is located in column B. Then try this formula in cell A2 and drag it down as far as is necessary:

Formula:

Please Login or Register  to view this content.

Hope this helps

Actually, try this formula instead. This will accommodate for blank rows in between branches:

Formula:

Please Login or Register  to view this content.

That almost works. But then the value for Branch 1 starts repeating after one vale of Branch 2. It also give a circular error:/

1 Branch 1
1 Name
1 Name
1 Name
1 Name
1 Name
1 Name
1
2 Branch 2
1 Name
1 Name
1 Name
1 Name
1 Name
1 Name
1 Name
1 Name
1 Name

BUT
really im looking for this 1 Branch 1
1 Name
1 Name
1 Name
1 Name
1 Name
1 Name
1
2 Branch 2
2 Name
2 Name
2 Name
2 Name
2 Name
2 Name
2 Name
2 Name
2 Name

That is correct Martin. B1 must be blank for my formula to work

Thanks very much
martin and ajryan

No problems!

Please don't forget to mark this thread as solved, and please click on the * next to my post to say thanks