| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I assign a numeric value to words in Excel?
What I need to do is assign a numeric vale to various words and calculate the
total. (e.g.) Warm=1 point, Hot =2 points, Scalding =3 points Cool =1 point, Cold =2 points, Freezing =3 points So if I have "Hot" and "Freezing" in one row is it possible to get the score total of 5? Thanks for any help I can get, Josh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I assign a numeric value to words in Excel?
Use a look-up table and the VLOOKUP function but don't forget to use
the False option if you enter your data into the table in numerical rather than alphabetical order. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Excel versions. | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Can you display numbers as words in excel (eg. 10 as ten)? | Excel Discussion (Misc queries) | |||
| Spell Checking - Special Words Not Picked Up by Excel | Excel Discussion (Misc queries) | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Linear Mode
