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
Related:

1 response

VBA is not required. Use this formula instead.

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

drag it down the list.
0