khalid79m
02-04-2010, 09:16 AM
I have a list of Keys in column B
Column B2 to say B500 (B500 this could vary(lastrow))
has keys in similar to the ones listed below
South_00123
South_00123
South_00154
South_00154
South_00154
South_00154
South_00154
South_00154
South_00159
South_00159
South_00159
I want to count the number of occurance in order
so
columnb ColumnC
South_00123 1
South_00123 2
South_00154 1
South_00154 2
South_00154 3
South_00154 4
South_00154 5
South_00154 6
South_00159 1
South_00159 2
South_00159 3
Can anyone help
Column B2 to say B500 (B500 this could vary(lastrow))
has keys in similar to the ones listed below
South_00123
South_00123
South_00154
South_00154
South_00154
South_00154
South_00154
South_00154
South_00159
South_00159
South_00159
I want to count the number of occurance in order
so
columnb ColumnC
South_00123 1
South_00123 2
South_00154 1
South_00154 2
South_00154 3
South_00154 4
South_00154 5
South_00154 6
South_00159 1
South_00159 2
South_00159 3
Can anyone help