Hi,
I'm creating a short phone survey questionnaire about TV show. It's made of 12 questions. Answers range from Yes/No, Age, ***, martial status....etc. the answers will be in the form of "List" (there will be only one selection). I made every answer start with a number (example 1 Yes, 2 No or 1 0-18, 2 19-24, 3 25-34, 4 35-44, 5 45+ and so on).
Each row represents one person being questioned, where each column is a question.
Example:
Did you see the show | Did you like the show | Your Age | Martial Status |
_____1 Yes_________|______2 No_________|__3 25-34_|____1 Single___|
_____2 No__________|______3 N/A________|__5 45+__|____2 Married__|
My question is: at the bottom of this sheet (there will be almost 3000 rows), I need to take just the first letter of each answer which is the number and then calculate how many yes (or 1) and how many No (or 2) and so on
Your help is really appreciated, thank you so much in advance.
Sam
Bookmarks