Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help giving a response a number value
I am trying to set up a new tracking system for our Patient Satisfacion cards
to be used in evaluation staff. I have a system now where I simply plug in the information into Excel and when it is time for a yearly review, I simply sort by Physical Therapist. I would like to know if there is a way to give each response a number value and set up seperate sheets for each Physical Therapist. Basically I want to enter Excellent on the tracking sheet...but for that Excellent response...give the Physical Therapist 5 points. Good = 4 points, Okay = 3 points and so on. Is this possible? If so, how the world do I do it? Thank you so so much for any help. I feel I am pretty good with Excel so if someone could give me some good directions, I am sure I could figure it out. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help giving a response a number value
Hi,
I would use VLOOKUP after creating a little table of your possible results and their numerical equivalents. =VLOOKUP(A1,C$1:D$5,2,) where A1 contains the result "Excellent" or whatever and C1:D5 is your lookup table. -- If this helps, please click the Yes button Cheers, Shane Devenshire "ConfusedatWork" wrote: I am trying to set up a new tracking system for our Patient Satisfacion cards to be used in evaluation staff. I have a system now where I simply plug in the information into Excel and when it is time for a yearly review, I simply sort by Physical Therapist. I would like to know if there is a way to give each response a number value and set up seperate sheets for each Physical Therapist. Basically I want to enter Excellent on the tracking sheet...but for that Excellent response...give the Physical Therapist 5 points. Good = 4 points, Okay = 3 points and so on. Is this possible? If so, how the world do I do it? Thank you so so much for any help. I feel I am pretty good with Excel so if someone could give me some good directions, I am sure I could figure it out. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help giving a response a number value
Do I put the table on the same worksheet as everything else?
"Shane Devenshire" wrote: Hi, I would use VLOOKUP after creating a little table of your possible results and their numerical equivalents. =VLOOKUP(A1,C$1:D$5,2,) where A1 contains the result "Excellent" or whatever and C1:D5 is your lookup table. -- If this helps, please click the Yes button Cheers, Shane Devenshire "ConfusedatWork" wrote: I am trying to set up a new tracking system for our Patient Satisfacion cards to be used in evaluation staff. I have a system now where I simply plug in the information into Excel and when it is time for a yearly review, I simply sort by Physical Therapist. I would like to know if there is a way to give each response a number value and set up seperate sheets for each Physical Therapist. Basically I want to enter Excellent on the tracking sheet...but for that Excellent response...give the Physical Therapist 5 points. Good = 4 points, Okay = 3 points and so on. Is this possible? If so, how the world do I do it? Thank you so so much for any help. I feel I am pretty good with Excel so if someone could give me some good directions, I am sure I could figure it out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I transform a word response to a numeric response? | Excel Discussion (Misc queries) | |||
Another SUMPRODUCT giving the incorrect number | Excel Discussion (Misc queries) | |||
SUMPRODUCT is giving incorrect number | Excel Discussion (Misc queries) | |||
Random Number response | Excel Worksheet Functions | |||
Function giving a result for number within a range | Excel Worksheet Functions |