| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Values to Letters?? Possible?
My boss has lately given me a new project an absence report for human resources. It has 8 categories (sick, personal, vacation, funeral leave, professional leave, jury duty, a.w.o.l., and worker's comp) thereare 70 employees and each has to be recorded each day. (mon-fri). Now that there's the background. Is there a way to give a letter a value? Say I enter V for vacation can I get the program to recognize it as a value of 1 then have all the v's total elsewhere? Sorry if that's confusing, but if anyone has any ideas, it would be much appreciated. DarklyConfused -- DarklyCute1 ------------------------------------------------------------------------ DarklyCute1's Profile: http://www.excelforum.com/member.php...o&userid=35949 View this thread: http://www.excelforum.com/showthread...hreadid=557354 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| How can I set number values for letters (eg. B, A-) in Excel 2003 | Excel Discussion (Misc queries) | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Threaded Mode
