Previous Topic Next Topic

VBA to assign a counter to a constant

Closed
azmi1965
Posts
1
Registration date
Wednesday December 31, 2014
Status
Member
Last seen
December 31, 2014
 - Dec 31, 2014 at 10:53 AM
 RayH - Jan 7, 2015 at 12:00 PM
Can somebody provide me the VBA code for the following samples
Before VBA code
A
B
B
A
C
A
C
A
After VBA code
1A
1B
2B
2A
1C
3A
2C
4A

Thanks

1 reply

Answer 1 / 1
RayH
Jan 7, 2015 at 12:00 PM
VBA is not required. Use this formula instead.

=CONCATENATE(COUNTIF(A$2:A2,$A$2:$A$9),A2)

drag it down the list.
0