| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions
Hello...
my questions is concerning functions... SD - Strongly Disagree D - Disagree N - No Opinion A - Agree SA - Strongly Agree i would like to add values to these phrases if you will...ie, SD = 1, D = 2,etc... i want to see the wrds in the original cell and get the numeric value when i enter the SD in another cell |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Functions
Hi,
assuming that your words are in column A enter your numbers in column B, then lets say that in column C you enter the words and want in column D to get the number. In column D enter =SUMPRODUCT(--($A$1:$A$5=C2),--$B$1:$B$5) If you have more than 5 words just change the range from A5 and B5 to your needs If this was helpful please say yes. thanks "Aspiring CPA" wrote: Hello... my questions is concerning functions... SD - Strongly Disagree D - Disagree N - No Opinion A - Agree SA - Strongly Agree i would like to add values to these phrases if you will...ie, SD = 1, D = 2,etc... i want to see the wrds in the original cell and get the numeric value when i enter the SD in another cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple functions, conditional functions | Excel Worksheet Functions | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| formula/functions for average and if functions | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
Hybrid Mode
