Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,748
- Office Version
- 365
- Platform
- Windows
I have workbooks of 100 of thousands of rows and I need a code please that will count the number of matching cells in column D and put a running count in column D please.
Please note it has to be a code rather than a formula. Thanks
Before
Excel 2010
<tbody>
</tbody>
After
Excel 2010
<tbody>
</tbody>
Please note it has to be a code rather than a formula. Thanks
Before
Excel 2010
C | D | |
---|---|---|
978 | AUA520D 1030 | |
979 | AUA520D 1030 | |
980 | AUA520D 1030 | |
981 | AUA520D 1035 | |
982 | AUA520D 1035 | |
983 | AUA520D 1035 | |
984 | AUA520D 1035 | |
985 | AUA520D 1035 | |
986 | AUA520D 1035 |
<tbody>
</tbody>
Sheet1
After
Excel 2010
C | D | |
---|---|---|
978 | AUA520D 1030 | 1 |
979 | AUA520D 1030 | 2 |
980 | AUA520D 1030 | 3 |
981 | AUA520D 1035 | 1 |
982 | AUA520D 1035 | 2 |
983 | AUA520D 1035 | 3 |
984 | AUA520D 1035 | 4 |
985 | AUA520D 1035 | 5 |
986 | AUA520D 1035 | 6 |
<tbody>
</tbody>
Sheet1
Last edited: