View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tayo Tayo is offline
external usenet poster
 
Posts: 6
Default Questionnaire - How can I automate the selected answers?

Dear All,

I am trying to set up a questionnaire with the following conditions:

There are 3 set of rows with different questions, each question can only
have one chosen answer out of 3 possible answers.


Possible Answers
Agree Indifferent
Disagree

Question 1:
Question 2:
Question 3:

Now the issue is that for the 3 questions, you can only select 1 agree, 1
disagree and 1 indifferent as answer. In other words, you can't have more
than 1 agree, 1 disagree and 1 indifferent in each of the 3 set of questions.
Please, what is the best way to go about this?

Here is a sample for further clarification:

Possible Answers
Agree Indifferent
Disagree

Question 1: Yes
Question 2:
Yes
Question 3: Yes