Hi i am trying to find a way to get different sequences on a single column according to the value on another column to the right of it. for example every time the value of the right column is "1" it adds to a specific sequence, every tiem its "2" it adds to another sequence. how could this be done? Here is an example of what i would want the code to do. I am looking o see if this can be done with excel formulas rather than VBA please if it is possible. Thanks
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
100000 | 1 | |
200000 | 2 | |
300000 | 3 | |
100001 | 1 | |
100002 | 1 | |
100003 | 1 | |
100004 | 1 | |
200001 | 2 | |
100005 | 1 | |
100006 | 1 | |
300003 | 3 | |
200002 | 2 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>