Hi all
Long time since ive posted on here!
I have a little problem and hoping some can help:
I have a list of branches (will be multiple rows per branch) and the region they sit within (North, Central or South) - branches will always be grouped together but the region might not be. And i want to number the unique branches within its region: For the purpose of this i'd like to avoid sorting the data and instead do it by formula:
So for example below i'd want to formulate the output in the 3rd column based upon the first 2 columns:
Any help would be hugely appreciated!
Thanks
Long time since ive posted on here!
I have a little problem and hoping some can help:
I have a list of branches (will be multiple rows per branch) and the region they sit within (North, Central or South) - branches will always be grouped together but the region might not be. And i want to number the unique branches within its region: For the purpose of this i'd like to avoid sorting the data and instead do it by formula:
So for example below i'd want to formulate the output in the 3rd column based upon the first 2 columns:
Branch | Region | Numbered |
1 | North | North 1 |
2 | Central | Central 1 |
2 | Central | Central 1 |
3 | South | South 1 |
4 | Central | Central 2 |
5 | North | North 2 |
6 | North | North 3 |
6 | North | North 3 |
7 | Central | Cental 3 |
8 | South | South 2 |
9 | South | South 3 |
10 | North | North 4 |
10 | North | North 4 |
Any help would be hugely appreciated!
Thanks