Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: I want to assign numeric values to letters in a speradsheet
Hi,
Any help would be very greatfully received! I am trying to work on a spreadsheet for a staffing rota. Each shift type has a letter (i.e. E or LS). I need to assign a numeric value to each letter that represents the number of hours of that shift (i.e. E= 5.5), so that totals can be calculated more easily... But I'm stumped! :s |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: I want to assign numeric values to letters in a speradsheet
With a letter in A1:
=LOOKUP(A1,{"A","B","C"},{1,2,3}) will give the numerical equivalent. modify to suit. -- Gary''s Student - gsnu200792 "Marion Black" wrote: Hi, Any help would be very greatfully received! I am trying to work on a spreadsheet for a staffing rota. Each shift type has a letter (i.e. E or LS). I need to assign a numeric value to each letter that represents the number of hours of that shift (i.e. E= 5.5), so that totals can be calculated more easily... But I'm stumped! :s |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: I want to assign numeric values to letters in a speradsheet
=VLOOKUP(E1,{"E",4;"F",3;"LG",5;"LS",5.5;"MA",4},2 ,FALSE)
adjust the values to suit You can put the values in a table and refer to that =VLOOKUP(E1,Sheet2!A1:B52,FALSE) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Marion Black" <Marion wrote in message ... Hi, Any help would be very greatfully received! I am trying to work on a spreadsheet for a staffing rota. Each shift type has a letter (i.e. E or LS). I need to assign a numeric value to each letter that represents the number of hours of that shift (i.e. E= 5.5), so that totals can be calculated more easily... But I'm stumped! :s |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: I want to assign numeric values to letters in a sperads
This doesn't seem to keep the letters displayed.
The idea is that the representative letters are displayed (E, LS etc) but are interpreted by Excel as values, which can then be summed etc. And pretty please can any replies be put as simply as possible, I'm not fab with excel :( Thanks! "Gary''s Student" wrote: With a letter in A1: =LOOKUP(A1,{"A","B","C"},{1,2,3}) will give the numerical equivalent. modify to suit. -- Gary''s Student - gsnu200792 "Marion Black" wrote: Hi, Any help would be very greatfully received! I am trying to work on a spreadsheet for a staffing rota. Each shift type has a letter (i.e. E or LS). I need to assign a numeric value to each letter that represents the number of hours of that shift (i.e. E= 5.5), so that totals can be calculated more easily... But I'm stumped! :s |
#5
|
|||
|
|||
If am set A=1,B=2,C=3...
I want AB=12 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver - Assign values to the letters of the alphabet | Excel Discussion (Misc queries) | |||
Solver - Assign values to Letters of the Alphabet | Excel Discussion (Misc queries) | |||
Solver - Assign values to Letters of the Alphabet | Excel Discussion (Misc queries) | |||
HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL | Excel Worksheet Functions | |||
ASSIGN NUMERICAL VALUES FOR LETTERS in EXCEL 2003 | Excel Worksheet Functions |