I need to assign values to a text string so that the larger of the two
columns of text (or the higher numeric value) can be found. Can this be
done? If so, how?

An example of what I need to do is:
C = 1
B = 2
A = 3
AA = 4
AAA = 5
SCS = 6
NRT = 7