hi mlbdc. would be better if you can upload a sample excel file. say your data is:
Data Range
A
B
C
1
RW
Rank
Subcat
2
1
1
C
3
2
2
SP
4
3
3
C
5
4
4
C
6
5
5
SP
=C2&COUNTIF(C$2:C2,C2)