Assign numerical values to text codes

[Guest]

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

 

[Ron Rosenfeld]

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

Simplest would be a lookup table. Use HELP to explore VLOOKUP (or HLOOKUP)


--ron

 

[Guest]

nested IF statements are the simplest way:

=IF(A1="A",1,IF(A1="B",2),...)

i.e., replace FALSE with your next test.

z.entropic

 

[CLR]

Put your text strings in J1 down to J7, and their numbers in K1 down to
K7.........add on the bottom if you have more...........
Then, assuming one of your test columns is A, put this formula in B1 and
copy down

=VLOOKUP(A1,J:K,2,FALSE)

do the same for the other column(s).........but change the "A1" as
appropriate......
Go to the empty cell just below your numbers in column B and click on the
AutoSum icon in the toolbar........this will sum the column for you.........

Vaya con Dios,
Chuck, CABGx3