R
ramon
I need to convert a list of text values and assign a number code
example:
Text Value Code
A- 7
A 6
A+ 5
AA- 4
AA 3
AA+ 2
AAA 1
example:
Text Value Code
A- 7
A 6
A+ 5
AA- 4
AA 3
AA+ 2
AAA 1
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
=8-MATCH(A1,{"A-","A","A+","AA-","AA","AA+","AAA"},0)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
T
Toppers
Assuming your text/code table is in columns A & B (A2:B8)and C2 contains
value to be converted:
=VLOOKUP(C2,$A$2:$B$8,2,0)
value to be converted:
=VLOOKUP(C2,$A$2:$B$8,2,0)
R
ramon
Thank you for the response Bob.
I am not sure how to use that formula, probably because I did not provide
enough detail for my query.
I am trying to create a table that will asssign a numeric value to a list of
characters.
In my example below, I am trying to assign a value of 7 to the alpha value
A- whenever it encounters it in a column of the spreadsheet (let's say column
C ), next I want to assign a value of 6 to the alpha value A whenever it
encounters it in column C ...and so on..
So I want to end up with each occurrence of the alpha value with an assigned
numeric code.
How would the formula be used? and Where would it be placed when using
multiple spreadsheets.? I supposed the value table will be on one spreadsheet
and the formula will be in the column next to where the data spreadsheet.
Thank you again for your help.
I am not sure how to use that formula, probably because I did not provide
enough detail for my query.
I am trying to create a table that will asssign a numeric value to a list of
characters.
In my example below, I am trying to assign a value of 7 to the alpha value
A- whenever it encounters it in a column of the spreadsheet (let's say column
C ), next I want to assign a value of 6 to the alpha value A whenever it
encounters it in column C ...and so on..
So I want to end up with each occurrence of the alpha value with an assigned
numeric code.
How would the formula be used? and Where would it be placed when using
multiple spreadsheets.? I supposed the value table will be on one spreadsheet
and the formula will be in the column next to where the data spreadsheet.
Thank you again for your help.
B
Bob Phillips
If the alpha value is in A1, put the formula in B1, and see what happens.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
R
ramon
Thank you Bob ...
Bob Phillips said:If the alpha value is in A1, put the formula in B1, and see what happens.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)