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

1 response

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

Similar discussions

fatal error: cache tryalloc:2331792 is greater then free hunk
rohit -
Smiley -

4 responses
Create folder in desktop with vba, if exist, ignore
viriato74 -
praveen -

6 responses