simonharry
New Member
- Joined
- Jun 17, 2016
- Messages
- 8
Hi All,
Not been here for a while. Hope you are all ok and can help.
<tbody>
</tbody>
I have 2 columns as above. I want to add the incremental count of each number in column A into column B to look as below using VBA.
<tbody>
</tbody>
Thanks Simon
Not been here for a while. Hope you are all ok and can help.
Column A | Column B |
A123 | |
A123 | |
A124 | |
A125 | |
A126 | |
A126 | |
A126 | |
A126 | |
A126 |
<tbody>
</tbody>
I have 2 columns as above. I want to add the incremental count of each number in column A into column B to look as below using VBA.
Column A | Column B |
A123 | 1 |
A123 | 2 |
A124 | 1 |
A125 | 1 |
A126 | 1 |
A126 | 2 |
A126 | 3 |
A126 | 4 |
A126 | 5 |
<tbody>
</tbody>
Thanks Simon