Hey,
Hope you all doing good. I'm in need of 2 formulas that goes in column C and column D.. or perhaps a code that could give me the results of column C and column D.
Column Column Column Column
A B C D
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
In above data column C is being calculated from column A's values only. Interestingly column D does the same with column B's values but every time a new value is seen in column A's target.row then the counting resets and starts from 1 again.
If someone could help me out here I'd appreciate it.
Thanks.
Hope you all doing good. I'm in need of 2 formulas that goes in column C and column D.. or perhaps a code that could give me the results of column C and column D.
Column Column Column Column
A B C D
a | ap | 1 | 1 |
a | ap | 1 | 1 |
a | as | 1 | 2 |
a | as | 1 | 2 |
a | as | 1 | 2 |
b | bi | 2 | 1 |
b | bo | 2 | 2 |
b | bo | 2 | 2 |
b | br | 2 | 3 |
b | br | 2 | 3 |
b | br | 2 | 3 |
b | bu | 2 | 4 |
b | by | 2 | 5 |
c | ca | 3 | 1 |
c | ca | 3 | 1 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
In above data column C is being calculated from column A's values only. Interestingly column D does the same with column B's values but every time a new value is seen in column A's target.row then the counting resets and starts from 1 again.
If someone could help me out here I'd appreciate it.
Thanks.