Sequential Numbering Based on Other Columns

[*shudder*]

Hi Guys,

I am looking to implement some form of automatic sequential numbering in column A to provide unique ID's based on the contents of two other columns. I have looked at various formulas options to achieve this, however they all seem alter the numbers if I sort or filter the data.

Example data set:

ID_EMP	Region	Branch	Employee	ID_REG	ID_BRA
101_1001_001	North	Glasgow	Smith, Paul	101	1001
101_1001_002	North	Glasgow	McKie, Tam	101	1001
101_1002_001	North	Edinburgh	Jones, John	101	1002
101_1003_001	North	Fife	Patel, Jo	101	1003
102_1004_001	South	London 1	Kaur, Mike	102	1004
102_1005_001	South	London 2	Jones, John	102	1005
102_1005_002	South	London 2	Smith, Paul	102	1005
103_1006_001	East	Norwich	Herd, Peter	103	1006
104_1007_001	West	Exeter	Smith, John	104	1007

Can anybody give me a steer of how this can be achieved?

Many thanks

 

[Joe4]

I have looked at various formulas options to achieve this, however they all seem alter the numbers if I sort or filter the data.

Yes, if you have formulas, they are dynamic, so if you change the sort order of your data, the values being returned by those formulas probably will change.
You may want to use VBA to create hard-coded ID numbers instead of using formulas.